adding a new sheet to a formulated workbook
 

If I add a new sheet that is formatted just like the other sheets in the
workbook will my totals formula add the new sheet?

adding a new sheet to a formulated workbook
 

Depends on what your formulas are.

This may help (or not):

Insert a couple of worksheets to surround your existing worksheets.

Call the one at the far Left, "Start" (w/o the quotes).
Call the one at the far right, "End" (w/o the quotes).

Then put the total sheet outside that "sandwich" of worksheets.

And use a formula like:
=sum(Start:End!g9)

You can drag sheets in and out of that sandwich to play what-if games.

And you can insert new sheets within that sandwich, too.

mattshoppe wrote:

If I add a new sheet that is formatted just like the other sheets in the
workbook will my totals formula add the new sheet?

--

Dave Peterson

adding a new sheet to a formulated workbook
 

Only if it is included in the range of sheets to be totalled in your 3D formula.

Best method for this is to insert a dummy sheet at beginning and name it Start

Insert one at end and name it End

3D reference will be =SUM(Start:End!cellref)

Any new sheets inserted between Start and End sheets will be included in your 3D
reference.


Gord Dibben MS Excel MVP

On Thu, 1 Feb 2007 13:33:02 -0800, mattshoppe
wrote:

If I add a new sheet that is formatted just like the other sheets in the
workbook will my totals formula add the new sheet?