Friday, March 26, 2010

Open Excel spreadsheets in a new window

I upgraded my machine to Windows 7 Pro yesterday, and one of the first things I ran into is Excel 2007 no longer opens spreadsheets in new windows. They all get lumped into one Excel window. This can be very annoying if you like working in multiple spreadsheets at once. There are various methods for allowing multiple windows in XP and Vista, but I had a tough time finding one for 7. Luckily, I finally did and am happy to report that it worked just fine on my machine (it's at the bottom of the page). It's a registry hack, so here's what you need to do on each OS (XP, Vista, and 7) in order to open spreadsheets in a new window

For XP and Vista, there a few a different ways reported that allow you to do this. I'll point you in a few different directions, but have not actually tried any myself. I only used the Windows 7 fix.

For both Excel 2003 and 2007, the setting for "Show all Windows in Taskbar" is said to work by some. In Excel 2003 you can find it in Tools->Options->View. In Excel 2007 you can find it by clicking the Windows button in the top right, then going to Excel Options->Advanced. From there scroll down to the Display section and check the box. This solution was posted here

For an XP specific solution, you can supposedly make a change to the file associations to force a new window when opening each spreadsheet. Here's how to do it:

1. Go to My Computer->Tools->Folder Options->File Types, choose XLS, then go to Advanced.
2. Uncheck "browse in same window"
3. In the Actions box, highlight Open and click the Edit button
4. In the "Application used to perform action:" box, remove the /e at the end and instead insert "%1" with the quotes. It should look like this: "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "%1"
5. Check the box for "Use DDE"
6. Delete anything that is in the "DDE Message:" box, and leave it blank
7. Make sure "Application:" says Excel
8. Empty the "DDE Application Not Running:" box
9. "Topic:" should say system
10. Click OK twice to get back to the File Types tab
11. Repeat steps 1-10 for the XLSX extension (if it's listed)

For Windows Vista I wasn't able to find a specific fix. However, when I used Vista I had no problem with spreadsheets opening in new windows and do not think I changed anything. If you are having the issue in Vista, I'd suggest first trying to uncheck the "Show all Windows in Taskbar" option named higher in the article. If that doesn't work make sure to go back and recheck that box, and then try using the same registry hack below that fixes Windows 7.

And of course, for Windows 7 you can do the following

1. Open Regedit so you can modify your registry. If you're worried about messing something up make sure to back it up first. You can do that by going to File->Export... and choosing a save location
2. Navigate to "HKEY_CLASSES_ROOT->Excel.Sheet.8->shell->Open"
3. Rename the ddexec folder to something else. If you're feeling brave, delete it
4. Now go into the command folder
5. Within the command folder you will see two keys: (Default) and command. You will want to change both of those, so start with (Default). Double-click on it
6. In the Value data box, delete the /e at the end and insert "%1" instead. Make sure to use the quotes too. Click OK
7. Now do the same to the command entry. Remove /e at the end and insert "%1" instead. Click OK
8. Excel.Sheet.8 refers to .xls files. To change this for .xlsx files as well, repeat steps 3-7 on the "HKEY_CLASSES_ROOT->Excel.Sheet.12->shell->Open" location
9. Close regedit
10. Try opening two spreadsheets. Each should open in their own window now

Hopefully that helps. I know it helped me. Thanks go to Turbo2001rt in the Microsoft TechNet forums for the fix. If you want to see the original TechNet article that helped me, you can check it out here. If you made it all the way through this article and either don't know what an xlsx file extension is for, or do not have xlsx as an option when you change your file type, check out my previous post for info about Microsoft's Office 2007 compatibility pack download.

1 comment:

Anonymous said...

Thank you so much! Opening files directly from excel so I can use my dual monitors has been making me crazy. This was a lot less scary than editing the registry directly (Which I tried, and failed at).