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