| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code for find function (reference cell value) | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
| Where to put code for access by all workbooks | Excel Programming | |||
| Where can I find TAPI code/reference for VBA? | Excel Programming | |||
Linear Mode
