Copying a formula to new workbook
 

Is there any way to copy a formula from one workbook to another without
bringing over the reference to the originating workbook.

If you're just bringing one formula, you can copy from the formula bar and paste
into the formula bar.

If you're doing lots then you can change the formulas to text, copy|paste, and
then convert those text strings back to formulas (in both workbooks):

select the range
edit|replace
what: = (equal sign)
with: $$$$$= (some unique string)
replace all

copy|paste

edit|replace
what: $$$$$=
with: =
replace all
(both workbooks)

===
Another option would be to let the links come across. Then use Edit|Links to
change the links to point at the current workbook.

Patrick Simonds wrote:

Is there any way to copy a formula from one workbook to another without
bringing over the reference to the originating workbook.

--

Dave Peterson