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

[Josiah]

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.)

[sokol92]

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

[clear]

@Josiah

Is there another method I might use to make sure there are no external links?

It is rather simple:

1. use Edit > Links to External Links to find the offending Source file and jot that down
2. copy the problematic ods to, say, xx.ods
3. unzip xx.ods
4. open content.xml in a text editor
5. look for xlinks and identify the offending one
6. delete the self-closing <table …/> that encloses it
7. save the edited file
8. recompress the components into a new ods
9. open the new ods
10. if necessary, run a global all-sheet search&replace of \n with ‘’

For unzipping and recompressing, see my notes here:
.
https://ask.libreoffice.org/t/calc-how-do-i-reduce-ods-file-size-by-resizing-embedded-images/131739/5