Try copying only the TEXT of the formula (without the equal sign), and then
adding the equal sign back in the new sheet..............

Vaya con Dios,
Chuck, CABGx3



"FCT" wrote:

How do I copy a formula from one .xls file to another without having the old
.xls file references come into the new .xls file that I am copying to?


Solving this problem will save me a lot of time. Otherwise, I have to
retype the really long formula in the new .xls file.

Thanks--