Copy across files

[emlu3]

I have a page of formulas on a worksheet in excel. I want to a create a copy of the formulas across to another worksheet in another excel file. However when I do this, the address of the old worksheet is copied as well. So the new sheet does the calculations of the values in the old file instead of the new one. Can anyone help me? Thanks

Emily

 

[nbrcrunch]

have you tried Paste-Special > Formulas?

(oh yeah, welcome to the board! )