When you have the two workbooks open in one instance of Excel, go to WindowNew
Window.

WindowArrangeVertical to have the two side by side.

Cuts down on the overhead of having two instances of Excel running.


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 21:57:24 -0400, "fred" wrote:

No

I want to be able to have 2 or more excel windows open side by side - like
the way word does it.

I can do it manually, by opening excel then go and open file, then open new
version of excel and open file, once I have 2 open I can rearrange on screen
so I see them side by side.

But this doesn't work if I open them from explorer - they all go to the same
excel.

"JP" wrote in message
...
You can toggle between workbooks by pressing Ctrl-Tab.

Is that what you were looking for?

--JP


On Apr 4, 8:00 pm, "fred" wrote:
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I click
on the next file it opens in the same excel, but on task bar it shows I
have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view data
side by side. This is default behavior on my system for Word - every time
I
click a word doc it opens a copy of word for each file.

I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks