excel 2010 remove the expressions from all Current Time Member properties

Team, we are getting error "Excel found unreadable data in  xxxx".  Could you tell me how to fix this?
Note,  I found a possible fix for the above error: "remove the expressions from all Current Time Member properties", could you tell me how to do that?

Thanks,  DG
Who is Participating?

Improve company productivity with a Business Account.Sign Up

NorieConnect With a Mentor VBA ExpertCommented:
All I can find is that 'Current Time Member' is a property of KPI.

Have a look at this link:


I know that doesn't help but I everything just seems to point towards the link I originally posted or to links like this.

Nothing about how to remove this member/property/whatever.

Perhaps if you include some other zones, eg SQL Server, OLAP, someone can help.
NorieVBA ExpertCommented:
Is this SharePoint or something linked to SQL Server?

There is this link but as far as I can see it doesn't really offer a solution, it does give you an idea of what could be causing the problem though.

ITSUPPORTAuthor Commented:
Hi, thanks for the answer.

No, this is not from SharePoint or something linked to SQL Server

Could you tell how to: "remove the expressions from all Current Time Member properties."
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

ITSUPPORTAuthor Commented:
Hi have seen this before, it is not helping me.  Could you tell how to: "remove the expressions from all Current Time Member properties."

Tks, DG
NorieVBA ExpertCommented:
So where does the workbook originate from?

Do any of the conditions described in the Cause section apply?
ITSUPPORTAuthor Commented:
I don't know the answer for the first question, this is in use by somebody else.

None of the conditions seems applicable, no pivot tables, no sql links...
ITSUPPORTAuthor Commented:
Ok, thank you very much for the help.  Much appreciated

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.