| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotals in Excel do not renewing automatically
Subtotals in my spreadsheets suddenly stopped working yesterday after several
years of being fine. Why would this happen? If I reinput the subtotals, they refresh for that instant only. What must I do to fix the problem? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotals in Excel do not renewing automatically
Go to Tools Options Calculation and select "Automatic
Let me know if this does not solve your problem. -- Laura Cook Neenah, WI "metcalf" wrote in message ... Subtotals in my spreadsheets suddenly stopped working yesterday after several years of being fine. Why would this happen? If I reinput the subtotals, they refresh for that instant only. What must I do to fix the problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to stop Excel from automatically selecting cells? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| Nested Subtotals in Excel 2003 -Solution | Excel Discussion (Misc queries) | |||
Hybrid Mode
