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
|