LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Links to other data sources

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Links to other data sources mr_teacher Excel Discussion (Misc queries) 2 May 16th 06 02:30 PM
Workbook contains links to other data sources?? sbrimley Excel Worksheet Functions 1 March 3rd 06 01:43 AM
Links to other data sources Graham Haughs Excel Discussion (Misc queries) 2 February 25th 06 01:55 PM
opening excel files with links to other data sources Saul Excel Discussion (Misc queries) 1 May 23rd 05 12:27 AM
Pivot tables, external data sources and ODBC links plato Excel Worksheet Functions 0 January 17th 05 05:07 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"