Automatic link

[Soe]

when i open a workbook, the warning prompts saying there are automatic link,
and ask if i want to update or not.
anyway to eliminate it?
btw, i don't hv any url link inside the workbook.

 

[Chris Nicholas]

This is by design of Excel.

In Excel XP you have the option to not prompt but the links will
automatically udpate.

The links that it is referring to are links to other workbooks not to
hyperlinks.

All other versions of Excel don't have this option so you would have to open
the file with code to get the prompt to go away.

Chris

 

[JPR]

I have never understood this either, but:

Using the links editor, find the excel file name it is TRYING to link with,
then search the entire workbook for all instances of that name and remove
from the formula ...

the formaula probably says something like :

=sum(A1+Sheet2!a1+[Mysterious]Sheet1!$a$1)

the "+[Mysterious]Sheet1!$a$1" is the part you wish to delete - you can do a
mass find/replace... it is rather easy in the end.

Cheers