TM1 web Error converting Excel to XML message

Post Reply
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

TM1 web Error converting Excel to XML message

Post by BigG »

Hi, I get an error on a new environment Tm1 web websheets (even the simplist one) will not open with message. Does anywone have experience and a potential fix for this? I cannot find anything specific on KB or tm1forum, thanks

Error occurred while converting the MS Excel workbook into XML
format : Exception from HRESULT: 0X800AC472
2011-06-14_1009.png
2011-06-14_1009.png (5.38 KiB) Viewed 3714 times
GG
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: TM1 web Error converting Excel to XML message

Post by moby91 »

BigG wrote:I get an error on a new environment TM1Web websheets (even the simpliest one) will not open

Did you check the DCOM permissions of the Windows user account running the Excel Report Server TM1ExcelService.exe ?


See the IBM Technote 1458332:

https://www-304.ibm.com/support/docview ... 58332&wv=1
Unable to launch TM1 websheet: Old format or invalid type library
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: TM1 web Error converting Excel to XML message

Post by BigG »

cheers moby91, you are a life saver... thought it was permissions and couldnt find the specific error on the IBM site, but your tech note is the answer.
GG
Post Reply