Every since Excel 2007 when you open more than one spreadsheet, you won’t get a second window. Depending on you’re workflow this may be a feature or a bit of a bummer. If you’d like excel to go back to opening new spreadsheets in a new window and you don’t mind a bit of setup there is a way.There are two different methods, to do this with the latest version of Excel (2010). First the easier of the two:
Make a shortcut on your desktop that opens a new Excel window (even if Excel is already open)
- Right click on the desktop
- Mouse over ‘New’ and select ‘Shortcut’
- Type or paste (with quotes): “C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE” /e
- Press Next
- Give your Shortcut a name like: New Excel Instance and press Finish
Every time you click on this it will open a new Excel window, however you’ll need to open spreadsheets through the file tab in each new excel window.
The second method relies on setting a little program I’ve written to “open” spreadsheets. The program actually just tells excel to open each spreadsheet in a new instance using a method similar to the one above. To use it:
- First download Open Excel.exe
- Make sure you save it somewhere you can find it later
- Next right click on an Excel spreadsheet
- From the General tab press the ‘Change’ button
- Click the ‘Browse’ button
- Find the Open Excel.exe program you downloaded earlier
- Select it and press ‘Open’
- Press ‘OK’ twice
Now when you open a spreadsheet there will be a slight delay but each spreadsheet will open in its own window.
Note: This program is offered free of charge and you may use or distribute it as you see fit, however the UUA is in no way responsible for any damage it may cause.