Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula won't update with new data
On all my Excel documents, when I create a formula, say just adding a column
of numbers, if I go back and change one of the numbers of data, the total won't change to reveal the new total. Did I accidentally hit a command key or something? thanks. doug |
#2
|
|||
|
|||
Doug, check tools, options, calculation, and make sure automatic is checked
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "D'oug" wrote in message ... On all my Excel documents, when I create a formula, say just adding a column of numbers, if I go back and change one of the numbers of data, the total won't change to reveal the new total. Did I accidentally hit a command key or something? thanks. doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |