I am getting a few error messages when trying to open an excel file with Excel 2007, the file is protected by password and has pivot tables in it:
- At first when opening the file it says "Unable to read file.", i press ok and it asks for the password, after the password i get the same error message and then it asks for the password again.
- After entering the second password i get another message saying "Excel found unreadable content in 'Book1.xls'. Do you want to recover the content of this workbook? If you trust the source of this workbook, Click Yes.".
- After i click yes i get a report of the repairs, all regarding the pivot tables: "PivotTable report 'Pivot Table X' on '[Book1.xls]XX' was discarded due to integrity problems.".
Any ideas if this is only due to file corruption or has it something to do with a certain excel bug, missing a hotfix maybe. The file itself is on a network drive and i'm not the only one working on it, that's why i'm suspecting corruption.
Appreciate any help ;-)
This issue occurs if the following conditions are true:
- 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
To resolve this issue, remove the expressions from all Current Time Member properties.
Hope that helps.
Hi Jennifer, thanks for your reply.
I have spoken to the creator of the original Excel file and she says she has no idea what KPIs are. She also mentioned that some of the data in the files is created from Oracle and then the user creates the pivot tables.
There is an article regarding the first error message of "Unable to read file." which refers to password protected excel files with pivot tables in them however the hotfix offered there is only for Excel 2002 product: http://support.microsoft.com/default.aspx?kbid=819853. Could this be the case also? and is there anything regarding that first error message for Excel 2007?