Copying/ moving formula between workbooks.

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!!
 
R

Ron de Bruin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy formulas to another workbook 4
Merge Multiple workbook sheets into one workbook 0
How to copy a range of cells and paste into a new workbook in differentcolumns 3
HELP - A formula or sheet you want to move or copy contains the name .... 0
Copy formulas between workbooks without copying links 8
Copying to a new workbook without formulas referencing original wk 1
Copy same formula to all worksheets in a workbook 1
Copy formula from one workbook to another without reference to 1st 4

Top