 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006Please help: identify where an automatic link to other spreadsheet is?
I have a spreadsheet with links to a couple of other sheets. However, how can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? go to menu Edit > Links... and remove the link you do not require. Lee Harris Wrote: > I have a spreadsheet with links to a couple of other sheets. However, > how [quoted text clipped - 9 lines] > > surely there must be a simple way to find out?  Signaturestarguy > go to menu Edit > Links... > and remove the link you do not require. no, that doesn't help - you get that prompt on startup anyway (not to mention the option to break/remove links often crashes excel) I want to know which cells are linking to the external sheets. > Lee Harris Wrote: >> I have a spreadsheet with links to a couple of other sheets. However, [quoted text clipped - 10 lines] >> >> surely there must be a simple way to find out? Lee Download and use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP >I have a spreadsheet with links to a couple of other sheets. However, how >can I find out which cells are linking to other sheets if I've forgotten? It [quoted text clipped - 4 lines] > >surely there must be a simple way to find out? Gord Dibben MS Excel MVP > Lee > [quoted text clipped - 3 lines] > > Gord Dibben MS Excel MVP many thanks Gord >>I have a spreadsheet with links to a couple of other sheets. However, how >>can I find out which cells are linking to other sheets if I've forgotten? [quoted text clipped - 7 lines] > > Gord Dibben MS Excel MVP Thanks Lee Bill's add-in has saved a lot of work for many over the years. Gord Dibben MS Excel MVP >> Lee >> [quoted text clipped - 17 lines] >> >> Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.