For some reason I can't read Luke M's response, so this may be the same
suggestion.

Make a copy of the 2nd workbook to work/test with. Copy the formulas from
the original into the copy and then close the workbooks.

Open the test copy and use Edit -- Links and Change Source to then browse
and point to the very same file you have open in its location on your hard
drive! If it works well with the copy, then do same thing to the original
(or just save the copy over the original 2nd workbook).

"Nadine" wrote:

Have 2 workbooks, want to copy a section from one to the other, but the cell
reference refers back to the other workbook.
If I was starting from scratch would just copy the sheet, but can't do that,
as workbooks already contain alot of data and charts, etc.

Just want the formula copied but refer to the cells in the new workbook, and
not reference the other workbook.

Workbooks are open in the same session of excel, not seperate sessions
tried paste special options but cells still refer back to the other workbooks,

Is there a way to do this, so that I don't have to recreate the forumals. As
I got to copy this same to 50 other workbooks.

Thanks
Nadine