Wednesday, May 16, 2012

Open two excel sheets at the same time

I tried the solution above for the Win7 Excel 2010 environment and was unsuccessful (using the same guide lines for Office14). I tried the following change and was able to open the two Excel windows properly.

Works for
Excel 2010 & Win7 (could work for 07 not tested)
------------------------------------------------------------------------
Open Registry Editor ver6.1

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command

(Note: it doesn't matter what is listed under default)

-Change the value command and under data remove /dde (above listed /e) and add after existing string the following code below

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

(Note: /p switch will ignore the (default) open settings)

-Go to Branch:
HKEY_CLASSES_ROOT\ExcelSheet.12\shell\Open\ddeexec

-Rename ddeexec2

1 comment:

Unknown said...

It works well without doing rename to ddeexec. :)

Thanks so much for your post!