Forum Discussion
"This Workbook contains links to one or more external sources that could be unsafe."
I have seen this quite a few times.
Happens when you copy and paste data from one excel workbook to the other. Instead of pasting the data, excel pastes a link to the data. Possibly a manual error or the pasting settings in one of the paerson you share the file with.
If you ignore the security warning, the last data when copied would be there. If you click on update, the data would be retrived again from the linked document.
If you want to find the link, do this:
1. in find and replace box, type '.xls' and hit 'find all'. You'll get all links referring to xls and xlsx files.
Once you find the cell, verify the existing data, then copy and paste as values on top of it.
NowshadAhmed I'm having trouble with the pop up whenever I open an excel file about links to one or more external sources. I'd like just to get rid of it. I tried "find all xls" but it just comes up empty. Where should I look please?
- First, thank you for your help. When I click on Formulas, and then on Name Manager, all I get is Define Name, Create from Selection and Defines Names, none of which have anything in a sub menu. Can you please hold my hand through this process. I just want to skip the extra step when opening a file.
- 1. Check formulas
2. Check named items in name manager
3. Check the source of data validation 'pick' lists
4. Check to see if any macro buttons are assigned to macros in an external workbook
5. Check the sources of any charts and pivottables
