I cannot see the result of a SUM in the worksheet, why?

[Nrippe]

I dio have a simple argument (Sum A17:L17). I cannot see the result in the
worksheet, however when I go through the function toolbar the result is
correct. Do you know what is causing this problem?

 

[Office Helper]

Does the cell look like this: =sum(A17:L17)?

 

[swatsp0p]

It is possible that your sheet is set to manual calculation. Press
F9...does the sum now appear? If so, click Tools>Options and click the
Calculation tab... make sure that Automatic is ticked.

HTH

Bruce

 

[Nrippe]

Yes, it does. I revise it many times wondering also about the = sign

 

[Nrippe]

Great! I will try that, thanks.

 

[Nrippe]

No, I checked, it's automatic.