Help on how to remove expressions from all Current Time Member properties.

[lebroyq]

Hi,

when I open a spreadsheet I get the following message

Excel found unreadable content in Book_Name. Do you want to recover the contents of this workbook.

All the information I find says
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.

and the fix is
To resolve this issue, remove the expressions from all Current Time Member properties.


My issue is - the spreadsheet with Pivot tables is supplied to me and I have no idea how to do the fix. I am using Excel 2007 - can someone give me some advice on how to remove the expressions?

BTW - when I do this on another machine same version of excel I have no issue

thanks for any help

[oldchippy]

Hi,

Can't say I've used this myself, but take a look here it may help you?

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

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

[Csaw]

Can anyone tell me exactly how to "remove the expressions from all Current Time Member and weight on the KPI properties".

[arlu1201]

Csaw,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.