Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum isn't updating automatically with new data entry
Should be a simple fix.
I am summing numbers in a column. When I enter new data in the column, the sum doesn't re-calculate automatically. If I re-type the same sum formula or click on the sum cell and hit return again, it re-calculates. It used to do this automatically with every new entry in the column. Have I unwittingly changed a setting to make this happen? How do I reset it so the total is automatically kept current? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum isn't updating automatically with new data entry
Paris wrote:
Should be a simple fix. I am summing numbers in a column. When I enter new data in the column, the sum doesn't re-calculate automatically. If I re-type the same sum formula or click on the sum cell and hit return again, it re-calculates. It used to do this automatically with every new entry in the column. Have I unwittingly changed a setting to make this happen? How do I reset it so the total is automatically kept current? Check Tools | Options | Calculation and make sure Automatic is selected. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum isn't updating automatically with new data entry
Go to Tools|Options and in the Calculation tab ensure Automatic is set on. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125772 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
Automatically updating data between worksheets. | Excel Discussion (Misc queries) | |||
Automatically Updating Data from Multiple Worksheets into One | Excel Worksheet Functions | |||
updating data entry | Excel Discussion (Misc queries) | |||
Sorting Data & Updating Automatically | Excel Discussion (Misc queries) |