Calculations may not occur in an Excel

[Salvador Rodriguez]

Hi, I'm having the exact same problems with multiple users on different excel workbooks; formulas just don't recalculates values, combination of F9 and cell format methods didn't solve the issue.
The only workaround I've found is copying a cell value within the calculation problem range and then pasting it to the rest of the range cells, then values are calculated correctly.
Have anyone found a permanent solution or identified the root cause?

Thanks.



Rubens Onofrio wrote:

ALT-CNTRL-F9
09-Sep-09

Hi Bob, Excuse my intrusion, but I'm having the same problem. I tried ALT-CNTRL-F9 and it works, but I have to press these 3 keys every time I enter a new data int the worksheet.

EggHeadCafe - Software Developer Portal of Choice
Dynamic Sql-based Self-Caching RSS 2.0 Feed Generator ASHX
http://www.eggheadcafe.com/tutorial...11b-a9f1fbd60cb5/dynamic-sqlbased-selfca.aspx

 

[Jan Karel Pieterse]

Hi Salvador,

Hi, I'm having the exact same problems with multiple users on different
excel workbooks; formulas just don't recalculates values, combination
of F9 and cell format methods didn't solve the issue.
The only workaround I've found is copying a cell value within the
calculation problem range and then pasting it to the rest of the range
cells, then values are calculated correctly.
Have anyone found a permanent solution or identified the root cause?

This sounds like a workbook corruption to me!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com