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