I have used code to duplicate 2 sheets 26 times each. Within in this
code i use a search & replace function to link the sheet to the
previous week's sheet.

The copy works fine, the formulas look fine. However, the totals from
one week are not carried through to the next week. I have to manually
select the formula and press ENTER.

Each sheet has approximately 30 linked formulas.

Could someone please suggest a way that doesn't mean I have to
manually go through all 52 sheets and re-confirm the formulas.

Thanks
Julie

Hi Julie

Did you switch Calculation Mode to Manual in your code, and forget to set it
back to Automatic?

--
Regards
Roger Govier

"jigsaw" wrote in message
...
I have used code to duplicate 2 sheets 26 times each. Within in this
code i use a search & replace function to link the sheet to the
previous week's sheet.

The copy works fine, the formulas look fine. However, the totals from
one week are not carried through to the next week. I have to manually
select the formula and press ENTER.

Each sheet has approximately 30 linked formulas.

Could someone please suggest a way that doesn't mean I have to
manually go through all 52 sheets and re-confirm the formulas.

Thanks
Julie