Do you need to open workbooks in separate windows in Excel 2007? If so, there is an easy fix for you. Just so you know, this only works with Excel 2007 in Windows Vista
Open Microsoft Excel 2007 and click on the Office Button. At the bottom of the menu, click on the “Excel Options” button.
On the left-hand navigation menu click the “Advanced” option and in the right-hand menu scroll down to the “General” section. Check the “Ignore other applications that use Dynamic Data Exchange (DDE)” check box and click the “OK” button.
Now try to open mulitiple Excel 2007 workbooks and they should open in separate, individual windows.
Thanks!!!
It mostly works in XP also. The only glitch I have noticed is double clicking a file does not open the file. It will launch excel but then you must open the file from within excel. If the spreadsheet in question is an email attachment or on a web site, save it to your desktop first then open it. This is close enough for me. Thanks for pointing out the correct option.
Perfect in XP too. Thanks.
It works .thank you very much
Wow. I felt stupid for not knowing this….not exactly an intuitive option.
This works in Windows & as well.
Whoops! Meant to say it works in Windows 7 as well.
This works in W7, BUT, it gives you an error when trying to open xlsx or xls files from
folders in “computer” or others. It says something like “Could not process called command”
If someone knew someother way to have independent individual excel windows, I´m all ears (eyes)
This did not work for me on Vista Home. I also had the same problem as elecbrick as you can then not open a file by double clicking on it. You’d think Microsoft could get something as simple as this right…I guess not.