Calc document thinks there is an external link, but there is not

When I open a certain calc file I get the message, “Automatic update of external links has been disabled”. However, there are no external links in the document. There had been such a link in the past, but it was changed to a lookup of an range internal to the document.

There are no macros in the document.

The problem occurs only in this file; no other file has the same problem.

So, two questions:

  1. I have used Search & Replace to try to find some external link, but no success. Is there another method I might use to make sure there are no external links?

  2. Assuming there are indeed no external links, how can I avoid the message I get every time the file is opened? (Please do not tell me to lower the macro security. That is not a solution.)

First step: Menu / Edit / Links to External Files.
If it does not help, then please upload your problem file.

1 Like