ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cells want automaticly update (https://www.excelbanter.com/excel-discussion-misc-queries/200790-cells-want-automaticly-update.html)

Jutty

cells want automaticly update
 
i got a file off my pda and it opens and runs in excel.
say i had A1 + B1 is the C1 cell.
I can change A1 but this will not change C1 until i open up the cell and hit
enter

David Biddulph[_2_]

cells want automaticly update
 
Tools/ Options/ Calculation
Set to Automatic, not Manual
--
David Biddulph

"Jutty" wrote in message
...
i got a file off my pda and it opens and runs in excel.
say i had A1 + B1 is the C1 cell.
I can change A1 but this will not change C1 until i open up the cell and
hit
enter





All times are GMT +1. The time now is 03:47 AM.

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