Hi Everybody!

The problem i am having is that i have a workbook with formula's linked to a variety of worksheets. What i want to do is replace some of the sheets and then the formulas automatically update.

However, when i add the new sheets (even after re-naming the sheets the same as the old ones i want to replace) all i get is #ref!

Is there a way round this as i have a lot of prepared work sheets that i want to "slot" into the original work book

thanks in advance