Formulas not updated automatically + Error Message

[Naveed Ul Haq]

Hello Excel Community,

I have two queries :

1. In specific cells, I have entered Sum & Division type formulas. When I enter data in source cells, its not updated automatically.

I have to go manually to the formula's cells, press F2 and then when press ENTER, data updates. Need to sort this automatically.

2. In some formulas cells, a yellow error link appears, saying there is data in adjacent cells. Every time I have to manually Ignore the error.
How do I get rid of this error to not appear again?

 

[Fluff]

Check that you have calculation set to automatic

 

[Naveed Ul Haq]

& what abt the error message?

Thanks for your help

 

[Fluff]

Go into file > Options > Formulas > either disable all error checking, or just disable the one you don't want

 

[Naveed Ul Haq]

Queries sorted.

Thanks a lot Fluff.

 

[Fluff]

You're welcome & thanks for the feedback