| 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. |
| 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 | |||
Threaded Mode
