If I'm only doing a few, I just delete the equal sign which turns the
formula into TEXT and then it copies fine, then just re-insert the equal
sign to turn it back into a formula again.....

Vaya con Dios,
Chuck, CABGx3


"tomcat" wrote in message
...
I want to copy a formula from one work sheet to another without the
formula
making a link in it...
I am using the latest excel version. Is there any way to make it "NOT"
insert the link to the copied spreadsheet?