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-07-20T10:21:43+00:00

if you're using Office 2007 - in the ribbon at the top go to View-> View Side by Side.

Not separate windows but allows you to see both spreadsheets. You can even switch on/off synchronised scrolling.
Was this answer helpful?

0 comments No comments
Anonymous

2011-07-18T18:40:32+00:00

In Excel 2007 , Click the Office button ->Excel Options -> Advanced .

Under General , check ‘Ignore other applications that use Dynamic Data Exchange’ .

Close Excel and open the two up. Both will open in two instances of Excel. Now remember, that DDE linking to other documents has been disabled, so if you use DDE, then you'll have to use theCompare Side By Side feature.

Same with Excel 2003.

In Excel 2003 , go to Tools -> Options ->General tab.

Make sure the option, ‘Ignore other applications ’ is checked. Now all the Excel files will be opened as separate instance

Same caveats with DDE and you can use the Compare Side By Side feature.

PEACE

Bud

Not

This worked perfectly! 2007 is finally useful!
Was this answer helpful?

0 comments No comments
Anonymous

2011-07-13T13:56:42+00:00

Why not open both files, go to the View ribbon and select arrange vertically. That should put them side by side. Of course you can tell the active book by the title bar color, but it's easy to switch back and forth.

Hope this helps!
Was this answer helpful?

0 comments No comments