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

Code to find formulas that reference other workbooks?
 

Bill Manville's FindLink comes to mind..
http://www.bmsltd.ie/mvp/MVPPage.asp#BillManville


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"excelguru" wrote in message
...
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