Code to find formulas that reference other workbooks?

  • Thread starter Thread starter excelguru
  • Start date Start date
E

excelguru

I have a workbook that (apparently) contains references to another workbook.
Upon opening, I get the usual "do you wanna update links?" window, to which
I say yes. I have no idea WHERE these references are (large spreadsheet -
not completely create by yours truly). My question is this: is there a
simple VBA code to help me pinpoint exactly where the external references
are located so I can modify them?

Thanks guys (and gals!),

Keith
 
Back
Top