Excel 2010 - Opening multiple files
Excel 2010 - Opening multiple files
(OP)
To my understanding Microsoft purposely designed Excel to open multiple files in a single instance. However, this keeps me from comparing them side to side the way I like it. I prefer to open excel files in their own seperate instances. I found in my searching to try to check "Ignore DDE something something...." but when I tried that, it no longer opened files from a windows folder.
All I want to do is open my windows folder where I have several excel files saved to. Click on a file and open it. Click on another file and open it in its own excel file and its own instance.
Is this even possible anymore?
All I want to do is open my windows folder where I have several excel files saved to. Click on a file and open it. Click on another file and open it in its own excel file and its own instance.
Is this even possible anymore?





RE: Excel 2010 - Opening multiple files
RE: Excel 2010 - Opening multiple files
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
There is a homework forum hosted by engineering.com: http://www.engineering.com/AskForum/aff/32.aspx
RE: Excel 2010 - Opening multiple files
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel 2010 - Opening multiple files
RE: Excel 2010 - Opening multiple files
If there is a way to change this by default, in 2010, I want to know!
RE: Excel 2010 - Opening multiple files
I actually discussed this with Microsoft phone support, probably 20 years ago. If I remember correctly, perhaps Excel 4 could run multiple instances but not so Excel 5 (and later). Anyway, that was all in the olden days. But the ""Show all windows in the Taskbar" would be the design intent of the programmers. So if you have multiple files in the same window, use the command under the View controls to control the view of the windows (tile, etc). There are even controls provided to "lock" the views of multiple windows so they scroll together. Or you can open each file in its own window.
Make this selection under the Excel Options/Advanced/Display (click the round "Office" button).
One thing you cannot do without being able to run separate instances of Excel is to open the same file in two windows and view the results when you make changes in one copy but not the other (this is something that I do dozens of times a day with another commercial software, and could not do my work without being able to do so).