Excel opening files in separate instances -why?

G

Gazza

I have 2 Excel files in a directory, clicking on each one in turn causes
them to open in different instances of Excel whereas I want them to be
different windows in the same instance.

Can anyone explain why this is happening and how to fix it (Excel 2000)

Thanks
 
L

LoriM

Hi Gazza,

Try going to Tools | Options | View Tab
Make sure Windows in Taskbar is checked.

HTH
LoriM
 
D

Dave Peterson

If you really mean two instances...

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
E

Earl Kiosterud

Gazza,

It probably isn't separate instances. You can still probably use Ctrl-Tab,
or Ctrl-F6, or Window from the menu bar to switch between the open
workbooks. There's a "Windows in Taskbar" in Tools - Options - View that
puts a task button on the task bar for each open workbook, as if they're
separate instances of Excel.
 
Top