PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Crashes
Formula does not run automatically.
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Crashes
Formula does not run automatically.
![]() |
Formula does not run automatically. |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
In the first sheet of my workbook I have formulas that pickup and add data
form other sheets in the same workbook. Every time I make changes in the data in other sheets the cells in first sheet do not get updated automatically. I have to go back to the first sheet, double click on the cell which has formulas and them press enter. Only then the cells bicks data from other sheets. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
Hi
Maybe you have set your calculations to manual. Go to Tools -> Options -> Calculations and set calculations to Automatic Regards, Bondi |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

