Copying/ moving formula between workbooks.

  • Thread starter Thread starter marsupilami
  • Start date Start date
M

marsupilami

Hi!

I want to copy a set of formulas from one workbook and paste them i
another workbook without any change!

However, when I paste them in the new workbook the formulas ALWAY
contain the reference to the old workbook! How can I avoid thi
reference?

(Other than manually copying the each cell's information).

Help will be greatly appreciated!!
 
You can use this

Use Edit>Replace
Replace "=" with " =", which converts formulas to text.

Copy the cells
Use Edit/Replace then to replace " =" with "=" To make them formulas again
 
Back
Top