Formulas not Calculating

[pgerardi]

Looking for some help. I have a simple worksheet that sometimes will not calculate (=sum). If I do a page down & then page up it will do the calculation but not automatically. Before anyone says to go to calculation options & make sure that it is set to Automatic, it is. This is making me a little uneasy.

Thanks

 

[MARK858]

The next common cause is circular references in your formulas, have you checked for them?

 

[pgerardi]

The next common cause is circular references in your formulas, have you checked for them?

There are no circular references.

 

[MARK858]

What is the column formatted as?

 

[pgerardi]

What is the column formatted as?

Number, Coma, 2 decimal places Bold. eg. (1,113,078.10)

 

[MARK858]

Is it doing the same in all workbooks?

 

[pgerardi]

Is it doing the same in all workbooks?

No, select few & doesn't do it all the time.

 

[Automatrix]

Try opening the file on another computer? Maybe it's a performance issue.

 

[pgerardi]

Try opening the file on another computer? Maybe it's a performance issue.

 

[pgerardi]

No, unfortunately others on the network have experienced the issue but with different files.