Thread: Please help: identify where an automatic link to other spreadsheet is?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Please help: identify where an automatic link to other spreadsheet is?
Lee

Download and use Bill Manville's FindLink program:

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


Gord Dibben MS Excel MVP

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
Reply With QuoteReply With Quote