Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Whenever I open a workbook of mine, it claims that it has links to other data
sources and asks if I would like to update the information. I know why it's saying this; it's actually linked to a temporary internet file from which I copied and pasted each sheet into a new document. I just can't find all the things that it's looking for. There were a lot of H and V Lookups which were linked due to named table arrays. I have found all of those and named the table arrays in my own document. I went through and used ctrl+F to find anything with the word "lookup" in it. Is there any way that I can find (without clicking each cell and looking) whatever the workbook thinks is linked to the other? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links to other data sources | Excel Discussion (Misc queries) | |||
Workbook contains links to other data sources?? | Excel Worksheet Functions | |||
Links to other data sources | Excel Discussion (Misc queries) | |||
opening excel files with links to other data sources | Excel Discussion (Misc queries) | |||
Pivot tables, external data sources and ODBC links | Excel Worksheet Functions |