View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Identifying and locating linking cells!

Use Bill Manville's free addin findlink.xla

found at Stephen Bullen's site:

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

--
Regards,
Tom Ogilvy

John Baker wrote in message
...
Hi:

I have somehow got links into a spreadsheet, and want to find them and

eliminate them. I
know how to break the links, but i am also importing data intro this

spreadsheet and
somehow am bringing in a link every time I import. THe problem is I have

been unable to
locate the specific cells that are causing the linkage.

Can someone tell me of a simple way to locate the cells that contain the

linkage, so that
I can remove this irritating problem!

I have tried turing on the ability to view formulas and that has not

helped. Are there any
other tools or techniques?


Thanks

John Baker