Thanks. I was having problems because I had 2 instances of Excel open and it
wont perform 'paste special-formulas' between the 2. However, now when I
paste the formulas they refer back to the original workbook. I suspect I will
have to use the replace function to get rid of all references?

"Ardus Petus" wrote:

EditPaste special
check Formula

HTH
--
AP

"tezza" a écrit dans le message de news:
...
I have 2 versions of a workbook. I've identified an error in some of the
formulas in one and having corrected them, I want to copy and paste into
the
other, but it only pastes the values. Any ideas?