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 |
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 |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com