June 27, 2016
I have a xlsm spreadsheet that I use regularly. When I open it, I get the message that the workbook contains links to other data sources.
When I click on edit links, a source comes up showing the name of the spreadsheet and the location.
When I follow guidance to Find external references in cells, whatever part of the link I try to find, I always get "Microsoft Excel cannot find the data you're searching for".
Could this link be hidden somewhere else in the workbook?
Regards,
TimC
VIP
April 21, 2015
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi Frans,
There is no such thing as vba links.
@TimC:
Most probably, there is a defined name that points to another file, you have to edit those names. Another place to sesarch is in shapes hyperlinks, these are the plces that can hold a link o another workbook.
Answers Post
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
No, Excel will not tell you that a link was created when you copy a sheet to another book. You will get a warning only when there is a name conflict, if there is already a defined name with the same name in the target workbook.
But you can always check the links from Data-Links. If there are no external links, the Links button will be greyed out.
1 Guest(s)