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?