Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding an external reference on a worksheet
I have a workbook which contains many copied sheets from other workbooks. I
have editted all of the formula so that they link only to sheets within the workbook and not to external worksheets. However, every time I load the file I get XL telling me that 'I have links to other workbooks, would I like to update them?' This isn't really a problem, I just click no and get on with it. The annoying thing is that I cannot find an external reference anywhere on any of the sheets. I have tried CTRL+F for #REF, [ and ], and .xls, all the things you'd expect to find in an external link. I've also checked all the source data on my charts for external references and not found any. For my own sanity and peace of mind, can anyone suggest a way to quickly find an external reference??? Many thanks. |
#2
|
|||
|
|||
Finding an external reference on a worksheet
Try searching for ]
-- HTH RP (remove nothere from the email address if mailing direct) "rmellison" wrote in message ... I have a workbook which contains many copied sheets from other workbooks. I have editted all of the formula so that they link only to sheets within the workbook and not to external worksheets. However, every time I load the file I get XL telling me that 'I have links to other workbooks, would I like to update them?' This isn't really a problem, I just click no and get on with it. The annoying thing is that I cannot find an external reference anywhere on any of the sheets. I have tried CTRL+F for #REF, [ and ], and .xls, all the things you'd expect to find in an external link. I've also checked all the source data on my charts for external references and not found any. For my own sanity and peace of mind, can anyone suggest a way to quickly find an external reference??? Many thanks. |
#3
|
|||
|
|||
Finding an external reference on a worksheet
Sorted it! Turned out to be the simplest of things....
My external links were in a hidden sheet that I was no longer using. Doh! Thanks anyway Bob. "Bob Phillips" wrote: Try searching for ] -- HTH RP (remove nothere from the email address if mailing direct) "rmellison" wrote in message ... I have a workbook which contains many copied sheets from other workbooks. I have editted all of the formula so that they link only to sheets within the workbook and not to external worksheets. However, every time I load the file I get XL telling me that 'I have links to other workbooks, would I like to update them?' This isn't really a problem, I just click no and get on with it. The annoying thing is that I cannot find an external reference anywhere on any of the sheets. I have tried CTRL+F for #REF, [ and ], and .xls, all the things you'd expect to find in an external link. I've also checked all the source data on my charts for external references and not found any. For my own sanity and peace of mind, can anyone suggest a way to quickly find an external reference??? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic worksheet reference | Excel Worksheet Functions | |||
FInding external link | Excel Discussion (Misc queries) | |||
How do I reference a worksheet name in a cell, or vice versa? | Excel Discussion (Misc queries) | |||
Get External Data Web Query new worksheet | Excel Discussion (Misc queries) | |||
AUTOMATICALLY REFERENCE SALES INFO FROM WORKSHEET #1 INTO INDIVID. | Excel Worksheet Functions |