Excel Calculation state is showing as Pending when it should be done


In Excel 2010 if you chart a volatile function, the calculation state will be in pending state when accessed through VBA code. In the Excel task bar it displays as ready.


This problem may occur when the following conditions are true: 

-You are using a volatile function such as NOW().
-You insert a chart displaying the value of the cell with the volatile function. 


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

If you edit a cell the calcuation state will be correct until the function updates.

आलेख ID: 2028670 - पिछली समीक्षा: 14/05/2010 - संशोधन: 1