Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
add cells from various pages in a summary page | Excel Discussion (Misc queries) | |||
Connected calculation of three cells | Excel Worksheet Functions | |||
Locked cells not updating | Excel Worksheet Functions | |||
Excel 2003 isn't updating my cells | Excel Worksheet Functions |