Forum Discussion
Automatic updates of links despite disabled
How to control the startup message about updating linked workbooks in Excel
To stop an automatic update, click on ...
File –> Options –> Advanced –> General –> Uncheck “Request update of automatic links”.
You have already made these settings as far as I could gather from your text...or?
Settings:
File -> Options -> Trust Center -> Trust Center Settings -> External Content.
From there, choose the top option for both items.
In the end, if none of this helps.
.. Try analyzing your workbook with Excel's own add-in "Inquire" and finding and removing the ghost links.
The trail might be of interest to you:
Formulas -> Reference to external workbooks
Cells -> With Validity Criteria
Cells -> With conditional formatting
Areas -> Named Items
Hope I was able to help you with this info.
I know I don't know anything (Socrates)