tags:

views:

83

answers:

1
Q: 

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

Hi guys, I get an error message that is annoying 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,

A: 

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

Michael  2010-08-17 12:27:56
thanks Michael. I am not using a pivot table though. I noticed this issue exists when I add new ranges to the spreadsheet. for example if i name a range B2:B7 as anything, the error message appears and when i remove this range < the error message is gone. I still don't know why
guest  2010-08-25 06:31:14

related questions

How can I find user's time zone offset in excel
One line macro
How to Reverse the Order of a Selected Range of Excel Columns using VBA
Return background color of selected cell
EXCEL VBA CSV Date format problem
VBA - "Can't find Project or Library" for standard VBA functions
Highlight and unhighlight specific ranges when a box is clicked
Why can't I set Application.ReplaceFormat.NumberFormat to some valid formats?
How do I avoid run-time error when a worksheet is protected in MS-Excel?
Can a vba function in excel return a range?
Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
Permission Denied opening an Excel File using Excel 12.0 Library & VB6
Find the directory part (minus the filename) of a full path in access 97
automatically execute an Excel macro on a cell change
What is a good up-to-date book for an experienced developer to learn Excel VBA?
Quitting Excel using VBA causes run-time error 424
Create an Excel macro which searches a heading and copy-paste the column
McAfee deletes code from VBA module
copying website data to XL 2003
How to adjust macro?
Manipulate a file in code (VB.NET) without executing the file's macros
How do I set the background color of Excel cells using VBA?
VBA-Sorting the data in a listbox, sort works but data in listbox not changed
Editing Embedded PowerPoint from Excel VBA
Top ten ordering in Excel based on complex team rules