Thread: [Solved] Need help with data links that seemingly cannot be broken
View Single Post
 
Old 04-24-2015, 05:36 AM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
Hi Doug,
Usually, the links can be found not only in cells formulas. You should always check in the list of defined names, at list that's what i did.
There is a name: Analysis, which refers to: ='C:\Doug D\TPU Excel Forms\HRMP\[HRMP Questionnaire SmartForm.Macro.xlsm]Validations'!$F$2:$F$6
If the list in this workbook, remove the external link: Validations'!$F$2:$F$6
Also, links can "hide" in hyperlinks associated with shapes.
Cheers,
Catalin
Reply With Quote