I have a file that was created by using Save As from a previous version. When I open the new file, I get a security warning asking if I want to allow external content. If I click Allow, then Edit Links, I get a window showing a link to the original version of the file (which no longer exists). If I highlight that filename and click Break Links, I hear a ding, but the link is still there.
Because of corporate security settings, I cannot set the file location as a trusted source, so I am faced with this warning every time I open the file.
I have tried to find the hidden link in the file by making a copy and deleting things one by one until I no longer get the External Data notice. I narrowed it down to one worksheet (if I delete that worksheet, the notice goes away), then tried deleting the data in that worksheet one column at a time. When I deleted all the data, I still got the notice, so I figured the link was hidden somewhere in the unused portion of the worksheet. I created a new sheet, then copied the data I need, and deleted the old sheet. However, I am still getting the Security Warning, and still cannot break the link.
Any ideas?
Bookmarks