Help removing expressions from all Current Time Member properties in Excel 2007

[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

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.