I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window

Anonymous

I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window. is there a way around this?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

I use Windows 7 and this is what works for me (just figured it out):

1. Open your first Excel file and place it on the screen you want

2. Open a new Excel file from the Excel icon

3. The new file will open on top of the one you have already opened. Drag it to the other screen

4. Drag the icon for the second Excel file INTO the new (blank) Excel document

Voila! Two separate screens.

0 comments

Answer accepted by question author

Anonymous

ok, just because i don't have the petiance to wait for you to answer to my first question about which excel version you'r using i'll just give my solution for all the people who have w7 and office 2007:

the solution involves making little changes in the registry so i recommend making back up for just in case:

strart - run - regedit:

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Right Click on Command – choose "rename" and add something to the name

for example 2 (commend2).

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:

Right Click on the folder ddeexec and choose "rename" and add something to the name

for example 2 (ddeexec2)

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write -****"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Right Click on Command – choose "rename" and add something to the name

for example 2 (commend2).

no restart needed

Have Fun

hope i helped

0 comments

285 additional answers

Anonymous

2011-12-10T18:35:45+00:00

okay, i like to help cuz i had the same problem. its really simple, first u open excel from your excel document for the 1st file, the 2nd file open it by going through start up, window office,excel , and search for your 2nd file and open it. That is it!
Was this answer helpful?

0 comments No comments
Anonymous

2011-12-05T08:48:59+00:00

Basically the same, but a more convenient solution on http://www.techrepublic.com/forum/discussions/8-195249:

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.

Repeat this for XLSX, CSV, ... whatever you open with excel...
Was this answer helpful?

0 comments No comments
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more