Solved

excel 2010 remove the expressions from all Current Time Member properties

Posted on 2011-09-08
7
2,510 Views
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
0
Comment
Question by:ITSUPPORT
  • 4
  • 3
7 Comments
 
LVL 33

Expert Comment

by:Norie
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.

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

Author Comment

by:ITSUPPORT
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."
0
 

Author Comment

by:ITSUPPORT
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
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 33

Expert Comment

by:Norie
ID: 36503140
So where does the workbook originate from?

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

Author Comment

by:ITSUPPORT
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...
0
 
LVL 33

Accepted Solution

by:
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:

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
 

Author Closing Comment

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

DG
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

757 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now