How to setup Microsoft Excel 2007 to open multiple windows?

How to setup Microsoft Excel 2007 to open multiple windows?

Vista solution:

1. Open Microsoft Excel 2007 as normally would

2. On the left hand side, look for the Office icon (big icon) and left click it for the menu

3. Choose the ‘Excel Options’ and then choose ‘Advanced’

4. On the right panel, go to the ‘General’ group

5. Select and choose the ‘Ignore other applications that use Dynamic Data Exchange (DDE)’ option and click okay

6. Close Excel

XP Solution:

1. Click on the ‘MyComputer’ icon

2. On the tools menu, choose the ‘Folder options’

3. Select “File Types” tab

4. Find the ‘XLS Extension’ and highlight it.

5. Choose the ‘Advanced’ button, then select ‘Open’ and ‘Edit’

6. At the end, append the “%1″

e.g. “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1″

7. Uncheck using DDE

8. Now repeat steps 4-7 for the ‘XLXS’ extension

9. Click okay and close out

4 Comments on How to setup Microsoft Excel 2007 to open multiple windows?

  1. Or you can edit the registry on Vista and Windows 7 and it does the exact same thing as changing the file association through XP. The way above for Vista causes some issues like opening blank sheets

    Delete the following lines in the registry:
    and change the below like shown:
    C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″
    C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″

  2. This registry changes do not seem to work in 64 bit Vista. Of course the paths change because of the (x86) modifier, but after making these registry changes, if I double-clicked on any Excel spreadsheet, Excel would open with nothing in it.

    The original solution at the top (Excel Options, Advanced, General) also did not work for double-clicking on an Excel file. However, it was possible to bring up to separate Excels, but you had to manually load the files.

    I must be doing something wrong.

  3. Did you actually try it?
    The vista solution is not working.
    error message pops up

  4. start->run->’excel’


Comments are closed.