Home |
Search |
Today's Posts |
#1
|
|||
|
|||
External Reference
Hi,
When I open a particular spreadsheet, the "Do you want to update External References...?" box appears, however I cannot locate the cells that refer to the external worksheets. I have tried a find on the file names listed in the links box, however there is no result. Is there a way to find the cells that refer to another file in Excel 2000? Thanks, |
#2
|
|||
|
|||
http://www.bmsltd.ie/MVP/MVPPage.asp
You need a file called filelink.xla an excel addin which will help you to find and delete links, it can be downloaded from the above. Rick "Iain" wrote in message ... Hi, When I open a particular spreadsheet, the "Do you want to update External References...?" box appears, however I cannot locate the cells that refer to the external worksheets. I have tried a find on the file names listed in the links box, however there is no result. Is there a way to find the cells that refer to another file in Excel 2000? Thanks, |
#3
|
|||
|
|||
You can use Edit/Find to look for "[" in formulas, and look in the
Insert/Name/Define listbox to see if a defined name refers to an external file. If you can't find it that way, you might try running Bill Manville's FinkLink add-in, which you can download from http://bmsltd.ie/MVP/Default.htm In article , "Iain" wrote: When I open a particular spreadsheet, the "Do you want to update External References...?" box appears, however I cannot locate the cells that refer to the external worksheets. I have tried a find on the file names listed in the links box, however there is no result. Is there a way to find the cells that refer to another file in Excel 2000? |
#4
|
|||
|
|||
"R D S" wrote in message
... http://www.bmsltd.ie/MVP/MVPPage.asp That URL is no longer valid. Use http://www.oaltd.co.uk/MVP/Default.htm instead. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "R D S" wrote in message ... http://www.bmsltd.ie/MVP/MVPPage.asp You need a file called filelink.xla an excel addin which will help you to find and delete links, it can be downloaded from the above. Rick "Iain" wrote in message ... Hi, When I open a particular spreadsheet, the "Do you want to update External References...?" box appears, however I cannot locate the cells that refer to the external worksheets. I have tried a find on the file names listed in the links box, however there is no result. Is there a way to find the cells that refer to another file in Excel 2000? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
External reference as a condition | Excel Worksheet Functions | |||
External reference as a condition | Excel Worksheet Functions |