Link update window opens on opening a linked Excel file

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have recently transferred my Office 97 applications to
a new computer running under XP. Since the transfer,
whenever I open a file which has links to another file, a
window opens saying:"The workbook you opened contains
automatic links to information in another workbook. Do
you want to update this workbook with changes made to the
other workbook? To update all linked information, click
Yes. To keep the existing information, click No."

The Automatic link update radio button accessed via
Edit/Links is set (and the Manual radio button is greyed
out). I have removed and then reinstalled the program,
but this aspect of its operation remains the same.

I don't know what else to try. Any suggestions would be
most welcome.

Thanks.
 
There's an option under:

tools|options|Edit tab
Ask to update automatic links
(I bet yours is still checked.)

And xl2002 has a new option.

Edit|Links|Startup Prompt button.
(my bet this hasn't changed, but it's nice to know about it.)
 
That' was it!

I feel dumb that I missed this one. Oh well. Can't win
them all!

Many thanks

Dave Ellis
 
Back
Top