2 excel files open in same window

  • Thread starter Thread starter Nese
  • Start date Start date
N

Nese

Using Excel 2007, I would like to have two or more excel files open in the
same window not in two different windows while opening them from windows
explorer.
Open the second file by choosing open from quick access bar is not what i
want to do.
The only way i found is to open the first file, then select the second's
name and drag it into the first opened excel window. But i know this is not
the right way.
Please advice
 
If I understand you correctly:

Office Button, Excel Options, Advanced, scroll down to Display section,
uncheck 'Show all windows in the taskbar'

HTH
Bob
 
Thanks Bob, but I have tried this, it doesn't work. I still display only 1
file in one window, the other is in an other one.
 
I know my comment comes a while after the original posting, but I had the same question and managed to figure out what I needed to do in my situation - since this post came early on my search results, maybe this can help someone else if you don't already have a solution.

From "My Computer" or or window's explorer (call it what you will),
Tools > Folder Options > "File Types" Tab
Select "XLS" and press the "Advanced" button
Select the "Open" action and press the "Edit" button
Make sure the "Use DDE" option has been ticked, and in the "DDE Message" type:

[open("%1")]

That did it for me. Hope that's helpful to someone else also.
 
Back
Top