Moving worksheets in a book

[Drakkip]

I am using a workbook to manage a database. The last page of the workbook
summarizes the data base by adding the same cell of each worksheet.

When I move any of the sheets in the workbook it appears to no longer
summarize the data correctly on my last summary sheet. I have to go to my
formulas, and copy and paste them.

Although I am not changing the content of any of the formulas in order for
it to properly calculate any new data inputted to the balance of any of the
worksheets will not be incorporated into the calculations.

Is there a solution other than to re-paste all the formulas on my summary
sheet?

 

[Albion]

Try F9 to refresh the calculations... if you don´t change the layout, and
are just changing the values, it´s just a matter of telling excel to re do
the calculation.
tell me if i didn´t get right ur question ...

Albion - Argentina

 

[Don Guillett]

if you have a formula =sum(sheet1:sheet10!a1) then just make sure all
additions are made within the range.

 

[Albion]

Nope, it doesn´t have to do with ranges... he´s summing up the same cell
(A1) in each worksheet.

Regards,
Albion - Argentina

 

[Gord Dibben]

Albion

How is the summing done?

What does the formula look like?

If 3D as Don suggests, make sure that the same sheets are always included in
the 3D.

One wy to ensure this is to insert a dummy sheet and beginning. Name it
Start.

Insert a dummy sheet just before the Summary sheet. Name it End.

3D formula on Summary sheet =Start:End!A1

Moving sheets around between Start and End should not pose a problem.


Gord Dibben Excel MVP

 

[Gord Dibben]

That should be

"One way to ensure this is to insert a dummy sheet at beginning"


Gord