Getting update pop up but have no external links

Shodi

Board Regular
Joined
May 24, 2016
Messages
53
Hi everyone. I have a work book with 23 sheets with basic IF, SEARCH, ISNUMBER, SUM, AVERAGE and IFERROR formulae and data validation, all in the same workbook.
I have not linked any cell or formula to a external source.
But every time I open the workbook I get a pop up "This workbook contains links to one or more external sources that could be unsafe" and then gives the option for "Update", "Don't Update" and "Cancel".
Like I mentioned there is no link to an external source that I have inserted.
How do I find the source/cause of this popup?
I am afraid that the data I have in the 23 sheets may be corrupted or altered in some way if this persists.
Please help.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Have you tried using Bill Manville's FindLink add-in to see if it can locate the source of the link?
 
Upvote 0
Thanks Rory. I downloaded Bill Manville's FindLink add-in it did the job.
However I am curious to know. The external reference that my workbook was popping up was due to a sheet named Hong Kong. All the links that referred to this sheet was replaced by Findlink.
The other sheets are named with single names like Bahrain, Malaysia, UAE etc.
Did the external reference happen because the sheet name was two words. If so is there a way around this??
 
Upvote 0
No, that would not cause an external link. You'd only get that if the link was to a sheet by that name in another workbook.
 
Upvote 0

Forum statistics

Threads
1,216,073
Messages
6,128,645
Members
449,461
Latest member
kokoanutt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top