ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell update - Automatically (https://www.excelbanter.com/excel-discussion-misc-queries/190940-cell-update-automatically.html)

Apoorva

Cell update - Automatically
 
In Excel Sheet 2003, I have pointed cell for doing calculation.
Recently I have observe that If i cahnge any cell data, All other cell are
not getting updatedl. I need to press F2 and press Enter button to refresh
the cell.
Kindly guide.

Dave Peterson

Cell update - Automatically
 
Maybe...

Tools|Options|Calculation tab|Check automatic

Apoorva wrote:

In Excel Sheet 2003, I have pointed cell for doing calculation.
Recently I have observe that If i cahnge any cell data, All other cell are
not getting updatedl. I need to press F2 and press Enter button to refresh
the cell.
Kindly guide.


--

Dave Peterson


All times are GMT +1. The time now is 03:51 PM.

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