Prev: Conditional Sum - Moving Average
Next: datevalue returns #value
From: Peter Cross Peter on 28 Mar 2010 10:04
I have 3 workbooks, payments payroll and receipts which are linked by formulas.
I want to use them as master copies and use them each year.
However when I try to copy and rename them the formulas always refer back to
the originals and not to the renamed files.
Can you help please?
From: Gary''s Student on 28 Mar 2010 10:57
With Excel closed, first make a backup of the three workbooks.

Then open all three workbooks. At this point each workbook can "see" the
other two as an open workbooks.

Then SaveAs each workbook with its new name. Then verify that the formulas
in all three workbooks refer to the "new name" versions.

Finally close the workbooks.


--
Gary''s Student - gsnu201001


"Peter Cross" wrote:

> I have 3 workbooks, payments payroll and receipts which are linked by formulas.
> I want to use them as master copies and use them each year.
> However when I try to copy and rename them the formulas always refer back to
> the originals and not to the renamed files.
> Can you help please?
 | 
Pages: 1
Prev: Conditional Sum - Moving Average
Next: datevalue returns #value