Hi,

I've 2 spreadsheets and I've a whole row of formulas I want to copy from one to the other. When doing this the formulas are changing to include the references back to the 1st spreadsheet. Which I don't want. Is there a way to copy the formulas so that they dont paste with references back to the original sheet?

Thanks,