Open each Excel spreadsheet in new window
I am sure you have noticed that when you already have a spreadsheet open and you open another via Windows Explorer it opens in the same instance of Excel. How great would it be to have each spreadsheet open in it’s own instance (multi monitors anyone?). Well you can and it’s easy to do. Just follow the instructions below.
You have to tell Excel not to use DDE to open the worksheet.
Open Windows Explorer, Tools, Options, File Types
Scroll down to XLS
Select Advance Button
Click on OPEN in the Actions window, Then Edit
On the 2nd line for application used add "%1".
Make sure to put the quotes around %1.
Example …\Excel.exe" /e "%1"
Write down what you see in the DDE Section.
You will need this information if you want to return to the original settings.
Now DeSelect Use DDE
When you double click on any XLS file a separate instance of excel will run. Another advantage is that you can open more than one XLS file with the same name.
Sourced from Techrepublic.
February 3rd, 2009 at 8:51 am
This page (http://www.pcman.net/open-each-excel-spreadsheet-in-new-window) addresses the exact problem I want to solve. How do I “Open Windows Explorer”? I tried opening “computer” (I’m in Windows Vista) and then in that window in the “Tools” drop down menu choosing “Folder Options” but there is no “File Types” option, nowhere to scroll down to XLS. How do I “Open Windows Explorer” to access Tools > Options > File Types?
February 3rd, 2009 at 9:55 am
The Windows Vista tool you use to change file associations in located in the Control Panel under the Default Programs icon.
February 11th, 2009 at 10:22 am
I’m sorry….how do you do that in vista? I’m there looking at Control Panel>Defaultt Programs>Set Associations and it doesn’t look like there is a way to adjust excel to open (each time) in a new browser. any help? thx
March 2nd, 2009 at 5:46 pm
Hi, this is a good option, but, do you know how to do that with a script? I have a problem, because i need to change this option in 200 computer and the beter option is using a scrip. I really apreciete your help. Thanks a lot
Pedro Luis
August 31st, 2009 at 10:37 pm
Bingo! i’m on multiple monitor right now and this is just exactly what i needed. MANY MANY THANKS TO YOU PCMAN COZ IT SURE SOLVED MY PROBLEM…GOODLUCK TO YOU & GOD BLESS!!!
November 24th, 2009 at 10:02 am
Works Great!! Many thanks!!
January 7th, 2010 at 6:30 am
Hi,
This doens’t work for me, when i try to open a sheet from my outlook it opens the excel sheet. But it is blank, only with the option to open a file.
I am not sure, but could this have anything to do with the exchange server.
I really want to get this working since it would save me hours every week.
Hope you can help me out.
January 10th, 2010 at 3:52 pm
You may have to save it from Outlook to your local machine and then try to open it.
January 21st, 2010 at 2:36 am
I couldn’t open my any excel file from any document folder.
I use following from this site. Thanks………….a lot.
Filed in Tech Tips on Sep.18, 2008
I am sure you have noticed that when you already have a spreadsheet open and you open another via Windows Explorer it opens in the same instance of Excel. How great would it be to have each spreadsheet open in it’s own instance (multi monitors anyone?). Well you can and it’s easy to do. Just follow the instructions below.
You have to tell Excel not to use DDE to open the worksheet.
Open Windows Explorer, Tools, Options, File Types
Scroll down to XLS
Select Advance Button
Click on OPEN in the Actions window, Then Edit
On the 2nd line for application used add “%1″.
Make sure to put the quotes around %1.
Example …\Excel.exe” /e “%1″
Write down what you see in the DDE Section.
You will need this information if you want to return to the original settings.
Now DeSelect Use DDE
When you double click on any XLS file a separate instance of excel will run. Another advantage is that you can open more than one XLS file with the same name.
Sourced from Techrepublic.