Identifying and locating linking cells!

J

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
 
P

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.
 
J

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
 
Top