On Sep 9, 10:31*pm, "Otto Moehrbach"
wrote:
Alan
* * Do you mean that when you copy a formula from one workbook to another
that a link is made to the old workbook? *If so, the cure is to not copy
formulas. The idea is to change the formulas so that they are no longer
formulas, then copy them, then change them back to formulas at the
destination. *

Not exactly, but your approach may still work.

When I copy the formulas, the formulas appear correct in the
destination workbook (not referencing the source workbook). The
formulas reference worksheets that did not exist in the source
workbook but do exist in the destination workbook. So, once I copy
them, it asks to update their values.

Alan