Excel 2003 with SharePoint 2003 and Analysis Services 2005
 

Hi,

I'm having this weird problem that a downloaded Excel 2003 NL file from
SharePoint NL can't update a pivot based on a cube in SSAS US.

The error message I get is: "XML for Analysis parser: The LocaleIdentifier
property is not overwritable and cannot be assigned a new value"

The SP-Services run an US-Server and the SSAS same story.

However! when I set the regional settiings to English, all is well but
English formatted dates and figures troughout the office is not acceptable.

Other solutions (but again not really acceptable):
- use mozilla (who downloads the excel-file and then opens it and not the
shared document solutions)
- open the excelsheet in IE (drawback here is losing some default excel
functionality)
- don't use SharePoint but the good old filesystem

Is this a BUG MS? I came to this conclusion because only when opening via SP
this error occurs. Any suggestions are welcome...
--
best regards,

Leon