OK, let's try again. I am in 1 workbook. I am trying to take 1 cell in 1
worksheest that has a function of summing a cloumn of about 10 cells. I want
that auto sum to show up in a different worksheet. I want the updated total
to reflect in both cells without having to go throught the update cycle of
closing the workbook, etc.

Please help.

Sheet1 A11 =SUM(A1:A10)

Sheet2 A11 =Sheet1!A1

Sounds like your "update cycle" may be due to having calculation on manual,
re-calculate upon saving.


Make sure you have calculation set to auto under ToolsOptionsCalculation.


Gord Dibben MS Excel MVP

On Mon, 10 Mar 2008 11:03:01 -0700, blhlambd
wrote:

OK, let's try again. I am in 1 workbook. I am trying to take 1 cell in 1
worksheest that has a function of summing a cloumn of about 10 cells. I want
that auto sum to show up in a different worksheet. I want the updated total
to reflect in both cells without having to go throught the update cycle of
closing the workbook, etc.

Please help.