Sign in
 
Home20132010Other VersionsLibraryForumsGallery
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
TechCenter >
> 
> 
OLAP of excel 2003 not working for excel 2010

已答复 OLAP of excel 2003 not working for excel 2010

  • Wednesday, June 13, 2012 12:54 PM
     
     
    Sign In to Vote
    0

    I have an excel file created in excel 2003 with pivot data from olap cube on windows xp
    system. now when i am trying to open the same file in ms excel 2010 with windows 7 os then i
    am able to open the file but not able to refresh the pivot.

    what should i do to refresh this pivot data.

    exception:

    "Xml for analysis parser: The localidentifier property is not overrightable and cannot be assigned a new value"

     

All Replies

  • Thursday, June 14, 2012 9:37 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    Here are some suggestions:

    Method1. Open the Control Panel > Regional and Language Options > Modify the "Advanced" tab "Language for non-Unicode programs" to be in the SAME language as the one specified in the "Regional Options" tab

    If method 1 is not worked, then try method2:

    Method2. Naviagate to the location of the oledb driver. It should be in: C:\Program Files\Common Files\System\Ole DB.
    Check the entries in msmdsrv.log. You should see that it's complaining about a missing message manager. You should notice that the locale ID matches the value set in Control panel.
    Now a workarround that I applied, without having to change the control panel was to copy the directory in .\resources\1033 (US english) to .\resources\4105 (Canadian English). This uses the US english entries until Microsoft releases the fix.
    Note: remember, this would have to be done on every client PC, accessing AS

    If both two methods cannot solve the issue, then try this:

    Method3. Update the latest version of your Microsoft SQL Server.

    Jaynet Zhang

    TechNet Community Support

     
  • Thursday, June 14, 2012 11:10 AM
     
     
    Sign In to Vote
    0

    Thanks Zhang,

    Some points to be noted.
    these steps are for win xp and I am using win 7. In Win 7 there are 3 program files
     and non of them has msmdsrv.log file on the location you mentioned.
    I checked the step 1 and the setting seems to be fine.

    Let me tell you one more thing that I am trying to connect a remote system for
    olap cubes and this system is having windows xp with sql server 2005.

    we are upgrading our win xp with office 2003 to win 7 with office 2010. and the files
    which i am trying to open is created in office 2003 and now i am trying to open in office 2010.

     
  • Friday, June 15, 2012 3:02 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    Try to download the OLAP PivotTable Extensions Release 0.7.4 to check the issue.

    http://olappivottableextend.codeplex.com/

    Jaynet Zhang

    TechNet Community Support