Copy Formula From 1 Workbook to Another

[Cecil]

I copied a formula from one workbook to another. Worked great ..
except that when I pasted the formula in the receiving cell, i
referenced the source workbook. I don't want to do that ... I want t
paste the raw formula, make a small change and recalc. My workaroun
was to edit the links and change the source to my receiving workbook.
That did it. My question > Is there an- easier- way to do this? ( i.e
not have to edit the links )

 

[Peo Sjoblom]

If it's only one formula copy it from the formula bar, if there are many

do edit>replace and replace = with q=, replace all
select all the formulas and do a regular copy and paste into the new
workbook/sheet,
finally reverse the replace in both sheets

replace q= with =

 

[Dave Peterson]

If you're doing one cell, you could copy from the formulabar, then paste into
the formulabar. You'll have to adjust the formula yourself.

If you're doing lots...
Select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Do your copy|paste

Then reverse it (in both worksheets/workbooks):

Select the range
edit|replace
what: $$$$$
with: =
replace all

Since you're copying text, you may have to change the ranges.

 

[Cecil]

Peo and Dave > Yes, that works. Thanks for the help. Cecil.

 

[Richard9278]

Cecil, Next time, try clicking on "Edit|Links|Change Source" and then
browse and select the open workbook to which you copied the formula.
It will convert all of the formulas automatically.