Formula does not run automatically.

[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.

 

[Bondi]

Hi
Maybe you have set your calculations to manual.

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

Regards,
Bondi