Moving worksheets in a book
 

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?

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

"Drakkip" escribió en el mensaje
...
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?

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

--
Don Guillett
SalesAid Software

"Drakkip" wrote in message
...
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?

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

Regards,
Albion - Argentina
"Don Guillett" escribió en el mensaje
...
if you have a formula =sum(sheet1:sheet10!a1) then just make sure all
additions are made within the range.

--
Don Guillett
SalesAid Software

"Drakkip" wrote in message
...
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

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

On Thu, 17 Feb 2005 20:47:46 -0300, "Albion" wrote:

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

Regards,
Albion - Argentina
"Don Guillett" escribió en el mensaje
...
if you have a formula =sum(sheet1:sheet10!a1) then just make sure all
additions are made within the range.

--
Don Guillett
SalesAid Software

"Drakkip" wrote in message
...
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?

That should be

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


Gord

On Thu, 17 Feb 2005 16:52:36 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Thu, 17 Feb 2005 20:47:46 -0300, "Albion" wrote:

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

Regards,
Albion - Argentina
"Don Guillett" escribió en el mensaje
...
if you have a formula =sum(sheet1:sheet10!a1) then just make sure all
additions are made within the range.

--
Don Guillett
SalesAid Software

"Drakkip" wrote in message
...
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?