Forum Discussion
Formula References error when saving
Find links (external references) in a workbook
...or
Workaround: resave the document in a temporary folder and then start deleting the individual spreadsheets. After each deletion, save the document again and this way you can find out in which worksheet the error occurred (i.e. if the error message no longer appears, you know that the error is probably in the worksheet you just deleted).
Then just remove the corresponding spreadsheet with the error from the original document and set it up again (or copy the spreadsheet from an older version and make adjustments so that it is up to date again).
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- raider917Sep 04, 2022Copper Contributor
NikolinoDE i did this. i found out the problem. it was graphs that i had that were showing up incorrect because i had added a row in their data range.