Excel found unreadable content in [workbook name] VBA error message

I get an error message that is annoy开发者_运维知识库ing me for a long time and could not fix it. I am writing a code in VBA Excel. Suddenly I got the following message: Excel found unreadable content in [workbook name]. then it asks me do you want to recover the content? Please help me to solve this, Thanks,

The following article by Microsoft addresses this issue. They list the possible causes as:

-The workbook contains a PivotTable that uses key performance indicators (KPIs). -The KPIs are created in the Analysis Services Business Intelligence Development Studio. -One or more of the KPIs have an expression in the Current Time Member property.

http://support.microsoft.com/kb/929766