Thank you - so far this has been the easiest method to use...but it seems SO
odd that sometimes I can copy formulas without making links to the copied
page and other times it makes them... almost like there should be a
"relative switch" somewhere.

K.

"CLR" wrote:

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?