«

»

Aug 28

Getting Excel to Open Sheets in New Instance

This is something that bothers me about Excel: it always opens worksheets in the same window. Then when I go to close one, it tries to close all of them. A couple of times, I was futzing around with a spreadsheet, closed a different one, clicked through the dialog on instinct, and saved over the original file I wanted to preserve.

Prior to Windows Vista, you could fix this problem from the folder options –> file type menu. Not any more.

I found this solution at blog.whitesites.com:

In the Registry Editor in Windows 7:

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command

Change the default value from

"C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE" /e

to

"C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE" /e "%1"

Rename the command key below it to “commandOLD” or something.

Then, rename the ddeexec key (one level up, I believe) to ddeexecOLD

This change will work for the .xls file extension (Excel 2003 files)

To do the same thing for Excel 2007 files, make the same changes (minus the “command” key, which didn’t exist here for me) at HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command.

I should have done this years ago. Must remember to do this on my laptop and make it standard on the YTG machine builds.

Leave a Reply