Open Excel 2003 files in a new window

If you’ve ever wanted to compare workbooks side-by-side in Excel 2003, but realized that Windows won’t let you do that easily, there is a workaround to allow that functionality. You basically tell the computer to open a new Excel instance instead of reusing the current one.

Here’s how:

My Computer --> Tools --> File types --> Go to ".xls"
Click "Advanced..."
Select "Open"
Click "Edit"
Add "%1" to the end of the command like so:
"C:\Program Files\Microsoft Outlook\OFFICE11\EXCEL.EXE" /e "%1"
Check "Use DDE"


That’s it. Now, when you double click on a file on your computer, you’ll get a new window and a wholly-contained Excel workbook you can drag anywhere. (You may have noticed that there are other commands to change besides the “Open” option. I haven’t messed with these, but that’ll give you something to try.)

One of the disadvantages of this hack is that the Excel instances don’t recognize each other. That’s apparent for things like when you want to copy or move tabs between two workbooks. For them to recognize each other you have to open them in the same Excel instance, which you can do by going to File –> Open within Excel.

February 24th, 2008

Suburbia sucks

This Atlantic article paints a gloomy forecast for the future of suburbs. I think there is some merit to the push into urban living. The article talks about lively streets and constant stimulation in a downtown setting. I also happen to think the idea of living with less space can be seen as a welcome challenge — it forces you to look at all the stuff you’re collected and think, “what do I really need?” We’re a nation of packrats; the new living style just forces the hand.

February 23rd, 2008

Why muni bond insurance sucks

Portfolio Magazine has a thorough and lucid article on what makes municipal bond insurance a complete scam. Too bad I didn’t own Ambac in 2004.

February 13th, 2008