LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Please help: identify where an automatic link to other spreadsheet is?

Thanks Lee

Bill's add-in has saved a lot of work for many over the years.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 23:32:25 GMT, "Lee Harris" wrote:


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Lee

Download and use Bill Manville's FindLink program:

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP


many thanks Gord



On Fri, 18 Aug 2006 08:28:58 GMT, "Lee Harris"
wrote:

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?


Gord Dibben MS Excel MVP



 
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
link a entire line in Excel to a spreadsheet I sort? Tontine2 Excel Discussion (Misc queries) 2 June 25th 06 03:21 PM
Working spreadsheet highlighting function for Excel 2007 Mr. Low Excel Worksheet Functions 4 June 16th 06 06:12 PM
How do i link Excel chart to Outlook automatic emails? beatacl Excel Worksheet Functions 0 August 18th 05 04:21 PM
Automatic update of information in a spreadsheet aolo7276 Excel Discussion (Misc queries) 1 April 12th 05 02:39 PM
Link Soucre changes when Spreadsheet opened from with within Outlook Cy Eze Links and Linking in Excel 0 January 6th 05 04:43 PM


All times are GMT +1. The time now is 03:32 PM.

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"