How to copy formula to a different workbook so it uses the new workbook's data?

[Holly Balasubramanian]

I would like to copy a formula (actually a worksheet full
of data analysis, which is a LOT of formulas) to another
workbook, and after I copy the formulas, I want them to
operate on the new workbook's data. I can only get the
stuff to copy and reference the old workbook's data and
calculate values for that. Is there a way to paste
without pasting the reference to the workbook name
itself? I do not want to have to change the workbook name
in ALL of the cells.

 

[Pierre Leclerc]

Hi

Use the find/replace in your new workbook to replace the referenc to
the old workbook with nothing

Find other interesting tips at:

http://www.excel-vba.com

I would like to copy a formula (actually a worksheet full
of data analysis, which is a LOT of formulas) to another
workbook, and after I copy the formulas, I want them to
operate on the new workbook's data. I can only get the
stuff to copy and reference the old workbook's data and
calculate values for that. Is there a way to paste
without pasting the reference to the workbook name
itself? I do not want to have to change the workbook name
in ALL of the cells.

Pierre Leclerc
http://www.excel-vba.com
(e-mail address removed)