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

Symptoms

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.

Cause

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. 

Resolution

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

प्रतिक्रिया