Links between files in different folders no longer dynamic

P

Peter Kane

I set up a series of Excel 2000 files in one folder an a
network drive some of which had links to files in another
network folder. These were dynamic, such that when two
files from different folders were open on screen changing
a linked cell would update the other file automatically.
(The formula shown in the linked cell would also show only
the file name and tab name not any of the folder detail,
this would re-appear when the linked file was closed).

I recently changed my PC (from a Toshiba Tecra 8100 Laptop
to an IBM Intellistation Z Pro). This new PC has the same
corporate Office 2000 platform as the laptop.

I now find that when I open two linked files from
different folder the file with the links continues to
refer to the closed file on disk and will only update if I
change the open file, save it, and update links manually.

Any ideas what is happening here?
 
D

Dave Peterson

It sounds to me like you have two instances of excel running--not just two
workbooks open in the same instance.

Try opening one of the files, then use file|open to open the other. My bet is
that things will look "normal" to you.

Sometimes doubleclicking on a file in windows explorer will cause a new session
to be opened.

A couple of suggestions to make windows/excel behave the way you like:

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

If that doesn't work, try one more guess:

Inside excel:
Tools|Options|General|Ignore other applications (uncheck it)

=========
And if you like to see multiple open workbooks/windows in the taskbar:
tools|options|View Tab|Check windows in taskbar.

And look at those icons on the taskbar. You'll see a difference in size/shade I
bet.
 
Top