Identifying and locating linking cells!

[John Baker]

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

 

[Tom Ogilvy]

Use Bill Manville's free addin findlink.xla

found at Stephen Bullen's site:

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

 

[pikus]

Are you importing from another Excel file?
How exactly are you importing it? Copy and Paste?
Have you tried to "Paste Special?"
If not, instead of pasting, right-click the top left cell you'r
pasting to and select "Paste Special" from the menue. Then selec
"Values" and click "OK.

 

[John Baker]

Thanks for the advice and suggestions.

That routine Tom pointed me to was most helpful. I had already been using
post/special/values (programmatically), and still have to figure out how the link got
there in the first place!

Thanks again

John Baker