Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each monitor.

Is there a way to force Excel to make a new instance of itself every time I open a new spreadsheet?

Replay

This will do what you want:

  1. Open the Registry Editor, browse to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open
  2. Delete the ddeexec key, (or just rename it if you are worried - I just renamed it and it worked)
  3. Click on the "command" key and replace the /e on the end of the (Default) and command strings in that key with "%1"

    The quotes around %1 are important and must be added.

    After the change the lines should look like this:

    (Default)   REG_SZ   "C:\Program Files (x86)\Microsoft Office\Office11\EXCEL.EXE" "%1 
    
    command   REG_MULTI_SZ   ']gAVn-}f(ZXfeAR6.jiEXCELFiles>[email protected]]Vz(r=f`1lfq`?R& "%1"
    
    
  4. Make the same changes to Excel.Sheet.12

Now both .xls and .xlsx should open in new windows with no errors.

If the files are static (on your desktop, My Docs, etc) then you can reference this link:

http://www.techonthenet.com/excel/questions/instance.php

If you have random files (from the Internet, E-Mail, etc) then you can do this to change the way it opens all XLS files to open in a new instance:

http://www.drewery.net/blog/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003/

If you like the existing behavior of opening documents in the current instance, and occasionally need a second copy of Excel to run, you can just launch a second copy of Excel from your favorite shortcut and drag-and-drop in the file you want.

The following would work for Win7 64 bit,(right click excel and open in new instance submenu) Open a notepad and paste the following and save it as:- Excel OpenInNewInstance.reg and right click mergeā€¦. you are done.. right click your excels and open in new instance

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\OpenInNewInstance]
@="Open In New Instance"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\OpenInNewInstance\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\""

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\OpenInNewInstance]
@="Open In New Instance"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\OpenInNewInstance\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\""
Category: windows Time: 2008-10-17 Views: 1

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.126 (s). 12 q(s)