Instead of deleting the old worksheet, why not just copy the cells and paste
them into the worksheet that has that same name.

luv2jeep wrote:

I have a spreadsheet with a number of tabs. The first tab is my "totals"
where there are formulas to total certain cells in each of the other tabs.

Each week I send the workbook out to a number of individuals asking them to
update the tab with their name. When I receive their replies, I delete their
old tab and copy in their new tab.

This breaks my formulas in the totals tab, even though the copied in
sheets's tabs have the same names.

Is there any way I can keep excel from tracking whether or not the tabs are
there until I am ready to calculate the totals? I already set them to manual
calculation.

Any help would be greatly appreciated.

--

Dave Peterson