Does anyone know of how to generate a list of all of the cells and the respective sheet in which they exist in a workbook that point to other workbooks I have inherited an enormous spreadsheet and I want to get rid of unnecessary links to other workbooks that want refreshing when I open it
Joe
Report links to other files
Hot Topic
- Application Error
- Prepare a list in excel for printing
- Running a macro if new mail if from a specific address
- sorting in ListView
- Trying to create a global variable
- Collection Item: Parent / NextItem
- Converting text file to excel file macro - help needed
- opc
- append excel data to text file
- Adding a command button to the toolbar or menu bar in Excel?
Microsoft ISV
- How to retrieve outlook e-mails
- How do connect an Excel file from Remote Server
- How do I call for all installed printers....
- Restrict editing of activity based on date comparison
- excel hyperlink - top/bottom of screen
- open a workbook with events turned off
- what is wrong with this formula? *9 Views & no one knows?*
- MS Office document and image writer print driver & port
- How we can get Exchange VSAPI?
- reformat TOC (table of content) and write it to text file
Report links to other files
redshock
Have a look at this free xla FindLink
http://www.oaltd.co.uk/MVP/Default.htm
lax4u
Joe