View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelguru excelguru is offline
external usenet poster
 
Posts: 5
Default Code to find formulas that reference other workbooks?

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