Copy formulaS between Workbooks

[Syslock]

This might be some sort of follow up question from Ken Runge post "Cop
formula between Workbooks" from Oct-23-2003. I would like to copy som
formulas from one workbook to another without getting a reference t
the original workbook

 

[Earl Kiosterud]

Syslock,

This happens, I think, where there are cell references to other sheets. One
way is to copy the text of the formula (drag across the text in the formula
bar), instead of the cell. Cell references won't adjust relatively when you
paste, though, though copying the pasted formula in the target workbook will
do so, so you can still make it work.

 

[Ture Magnusson]

Syslock,

Don't copy the cell. Select and copy the formula text in the the
"Formula Bar" above the worksheet. At least that's what I do.

 

[Gord Dibben]

One method is to select the range of formulas in book1 and Edit>Replace

what: =
with: xx=

Do your copy over to book2 then reverse the Edit>Replace

Gord Dibben XL2002

 

[Syslock]

And how about to copy a register from one worksheet to another where
also get the reference to the original