Formula does not run automatically.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
Maybe you have set your calculations to manual.

Go to Tools -> Options -> Calculations and set calculations to
Automatic

Regards,
Bondi
 
Back
Top