I have tried everything I can think of, and everything the internet has to offer:
- Find function
- Go-To Special, Objects – manually inspect each
- An add-in for finding external links
- Manually searching charts and chart names
- Manually searching conditional formatting
- Manually searching all new cells since the error started appearing
- Data – connections list (empty)
- Formulas – name manager list (empty)
- Maybe more – I'm losing track
There just aren't any external links! But the error persists. There are no pivot tables, there are no tables, there are no macros. Any other ideas? Please?
PS. the error actually isn't causing problems – everything works, it's just a bar at the top of the page in SharePoint, but people I work with are panicking and I can't convince them that it's not a issue, so now it is.
Best Answer
I was able to get rid of the error by checking out the file, editing IN EXCEL (and only changing the spelling in an arbitrary text cell), uploading, and checking back in. Bizarre, but issue solved.