I have a group of complex spreadsheets that always trigger a "This workbook contains links to other data sources" message when opened. When I open the Edit Links dialog, the phantom link shows the following
[sharepoint website url]/Users/[user name]/AppData/Local/Micros
-to break the link
-to change source to another workbook
-searched the entre workbook for formulaic links with "["
-deleted all Named Ranges, including hidden names using the Decision Models Name Manager utility
-searched for hidden objects with GoTo>Special>Obiects
I'm out of ideas. I've found no programmatic way to fix it using VBA. Anyone have any thoughts?