Excel opening files in separate instances -why?
 

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

Hi Gazza,

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

HTH
LoriM

"Gazza" <mallin"nospam" wrote:

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

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.



Gazza wrote:

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

--

Dave Peterson

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.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Gazza" wrote in message
...
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