This bug has been around for more than a half decade.
For files files with no External Links, Calc gives the Security Warning Automatic update of external links has been disabled.
xx2.ods (6.9 KB)
As a user, the hack to fix such a file:
- use Edit > Links to External Links to find the offending Source file and jot that down
- copy the problematic ods to, say, xx.ods
- unzip xx.ods
- open content.xml in a text editor
- look for xlinks and identify the offending one
- delete the self-closing <table …/> that encloses it
- save the edited file
- recompress the components into a new ods
- open the new ods
- 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