Welcome

How to open a new instance of Excel 2007 workbooks (Windows 7)

If you work with Excel a lot, you’ve probably noticed that each workbook you open doesn’t create a new instance of Excel. There are not several tabs for Excel in your taskbar like for Internet Explorer or other programs.

Why is this and how can it cause problems? For the most part, it’s not a big deal and doesn’t bother most Excel users. However, it is a real pain when working with many spreadsheets and they are treated as a group.

For example, let’s say you decide to calculate everything on one spreadsheet. Well, if you have others open, Excel will recalculate all of them too as if they are somehow related. If this is what you want, great, but if not, there’s no way to stop it!

Here’s how you can solve that problem…

First (easier) solution is to install a program called Excel Instance Launcher. You can download it here

Second, not so handy solution involves making little changes in the registry. So, before doing anything, make a backup just in case!

strart – run – regedit:

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:

Right column {adding (space)”%1″}

Double Click on (Default) and write – “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1”

Right Click on Command – choose “rename” and add something to the name  – for example 2 (commend2).

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:

Right Click on the folder ddeexec and choose “rename” and add something to the name  – for example 2 (ddeexec2)

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:

Right column {adding (space)”%1″}

Double Click on (Default) and write – “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1”

Right Click on Command – choose “rename” and add something to the name  – for example 2 (commend2).

No restart needed. Have fun.

via: http://answers.microsoft.com/en-us/default.aspx


2 Comments on “How to open a new instance of Excel 2007 workbooks (Windows 7)”

  1. 1 Optimize Your Windows 7 | dberak said at 6:48 am on February 10th, 2011:

    […] Also read: Windows 7 Keyboard Shortcuts To Increase Productivity and Windows 7 Hidden Themes – Discover additional 18 Wallpapers and How to open a new instance of Excel 2007 workbooks […]

  2. 2 Max said at 1:40 pm on June 9th, 2011:

    This will not work with DDE opening e.g from email.

    So far only solution i found is batch file


Leave a Reply