excel 2010 remove the expressions from all Current Time Member properties

Posted on 2011-09-08
Last Modified: 2012-05-12
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
Question by:ITSUPPORT
  • 4
  • 3
LVL 33

Expert Comment

ID: 36502814
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.

Author Comment

ID: 36502877
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."

Author Comment

ID: 36503005
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

LVL 33

Expert Comment

ID: 36503140
So where does the workbook originate from?

Do any of the conditions described in the Cause section apply?

Author Comment

ID: 36503904
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...
LVL 33

Accepted Solution

Norie earned 500 total points
ID: 36504034
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.

Author Closing Comment

ID: 36506406
Ok, thank you very much for the help.  Much appreciated


Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question