I select my range to copy
edit|replace
what: = (equal sign)
with: $$$$$= (some unique string)
replace all

Now my formulas are just text.

Then copy|paste

Then clean up both ranges:
select the range
edit|replace
what: $$$$$= (that same unique string)
with: = (equal sign)
replace all

Now my text strings are formulas again.

(Make sure you have worksheets in that new workbook that match up--else you'll
be dismissing lots of dialogs!)

I'd fix one formula manually just to test.

===
Alternatively, copy and paste like you did
and then edit|links|change source
may work nicely for you.

ron wrote:

Hello,
I want to copy and paste several cells, each containing
formulas, from one workbook to another. The formulas
contain references to several different sheets and I want
the paste to contain the formulas exactly as they are in
the originating workbook. When I paste these cells into
the destination workbook, however, the formulas have
inserted in them links to the originating workbook file
name.

The only way I can see to solve this problem is to
individually select each cell, copy its formula from the
edit formula field and then paste it into the edit formula
field in the destination workbook. There are a lot of
cells to copy and paste, so doing this cell by cell is not
very feasible. Does anyone have any suggestions? Is there
an option in Excel to disable the workbook link appearing
in the formulas in the target workbook?

thanks
Ron

--

Dave Peterson