Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
80
Views
Topic starter
Hi Team,
My Excel sheet has several sheets link to SQL.
When I open the work book I have attached message box saying "We can't update some of the links in your workbook right now"
when I go into Edit link, I have another message box saying source is 'Book1"
I cannot find "Book1" worksheet even under VBA project (may be the way I tried to find very hidden one is not good enough).
Please guide me to find the worksheet to unlink.
Thank you.
Regards,
Aye
Posted : 18/10/2019 2:48 am
Hi Aye,
Check the Names Manager, it's possible that one of the names has references to those external sources.
Another place where links can "hide" is in shapes hyperlinks.
Posted : 18/10/2019 9:54 am
