ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula won't reflect new cell data (https://www.excelbanter.com/excel-worksheet-functions/9505-formula-wont-reflect-new-cell-data.html)

D'oug

Formula won't reflect new cell data
 
I think I accidentally hit a key command and now when I create a formula (say
just adding a column of numbers), if I go back and change one of those
numbers in the column, the Total doesn't update.

Any help greatly appreciated

Peo Sjoblom

Toolsoptionscalculation and set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"D'oug" wrote in message
...
I think I accidentally hit a key command and now when I create a formula
(say
just adding a column of numbers), if I go back and change one of those
numbers in the column, the Total doesn't update.

Any help greatly appreciated





All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com