UPDATING CELLS THAT HAVE BEEN CONNECTED FROM DIFFERENCT PAGES
 

I HAVE A CELL THAT IS THE SUM OF 2 OTHER CELLS THAT HAVE ALREADY BEEN
SUMMED(I.E. =SUM K5:K35), ONE CELL IS FROM ANOTHER WORKSHEET. THOSE CELLS
HAVE BEEN TOTALLED ON SHEET ONE USING THE FORMULA
=SUM(SHEET1!K35+SHEET3!k35). BUT THIS CELL IS NOT BEING UPDATED WHEN THE
NUMBERS CHANGE ON THE OTHER SHEET OR WHEN NUMBERS ARE ADDED TO THE COLUMNS
THAT ARE BEING SUMMED.

CAN SOMEONE HELP? AUTOMATIC IS ON.

UPDATING CELLS THAT HAVE BEEN CONNECTED FROM DIFFERENCT PAGES
 

Have you got a circular reference? Are you saying that you are adding cells
K35 from 2 sheets, but that these in turn contain SUM(K5:K35)?
[And please don't SHOUT.]
And if you want =Sheet1!K35+Sheet3!K35 you don't need SUM()
--
David Biddulph

"XCELME" wrote in message
...
I HAVE A CELL THAT IS THE SUM OF 2 OTHER CELLS THAT HAVE ALREADY BEEN
SUMMED(I.E. =SUM K5:K35), ONE CELL IS FROM ANOTHER WORKSHEET. THOSE CELLS
HAVE BEEN TOTALLED ON SHEET ONE USING THE FORMULA
=SUM(SHEET1!K35+SHEET3!k35). BUT THIS CELL IS NOT BEING UPDATED WHEN THE
NUMBERS CHANGE ON THE OTHER SHEET OR WHEN NUMBERS ARE ADDED TO THE COLUMNS
THAT ARE BEING SUMMED.

CAN SOMEONE HELP? AUTOMATIC IS ON.