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
ITSUPPORTAsked:
Who is Participating?
 
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:

http://msdn.microsoft.com/en-us/library/ms146057.aspx

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.
0
 
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.

http://support.microsoft.com/kb/929766
0
 
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."
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
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
0
 
NorieVBA ExpertCommented:
So where does the workbook originate from?

Do any of the conditions described in the Cause section apply?
0
 
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...
0
 
ITSUPPORTAuthor Commented:
Ok, thank you very much for the help.  Much appreciated

DG
0
All Courses

From novice to tech pro — start learning today.