I just did a simple test making two workbooks, having a sheet in each book
names the same and copied a simple formula from the 1st workbook to the 2nd
and it just copied the formula and did not refer back to the 1st sheet. can
you give furhter data, as in what the formula is and what the actual cells
are that are being copied and pasted?

"Bill Viverette" wrote:

I have two workbooks with idential worksheet names. I need to copy a
formula from a worksheet in workbook A to the same relative worksheet in
workbook B. But I want the pasted cell/worksheet references in workbook B to
refer to the worksheet in workbook B and not back to the worksheet in
workbook A. If I do a simple copy/paste I get references back to worksheet
A. I see no way to do this with Paste Special. Any ideas?

Thanks in advance,

Bill