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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
Excel, assign cells in multiple worksheets from one sheet 1
Excel Count If Formula Question 1
Formula Result Does Not Change when a component does 3
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel Drag autofill only part of formula 3
linked cells will not update 1
Reference Separate Sheet for Formula 2

Back
Top