TM1 Web - Websheets Opens as Excel Files

[jorelb]

Would appreciate any assistance in resolving a TM1 Web issue. Websheets in our development box opens as excel files and not as webpages. The excel files were loaded in TM1 Application folder using Server Explorer. Our system configuration is: Windows x64, TM1 9.4.1 FP3 & Excel 2007 SP 2.

Thank you

[rkaif]

Are you trying to open the Files uploaded to the application folder through the TM1Web or through the Server Explorer?

Files opened through the Server Explorer will be opened in Excel. On the other hand if you will try to open the same file in TM1Web it will opened within the browser as a websheet.

[jorelb]

The files are opened from TM1 Web but are opening up as excel.

Thanks

[zermatt]

We experienced the same problem after we had installed TM1 Web 9.4.1 FP3. A Restart of the Excel Services helped.

Regards

[lotsaram]

This error is intermittent in version 9.5 and 9.5.1 also but only for .xlsx files and not .xls. A restart of the TM1ExcelService usually fixes it, if not a reboot of the physical server itself seems to do the trick. As to why it happens I can't help you.

[jorelb]

Thank you zermatt and lotsaram for your inputs. I tried both restarting the excel service and bouncing the box and it did not fix the problem. I contacted IBM support and we are going to uninstall and reinstall the TM1-Web and see if it resolves the issue.

[jorelb]

The TM1 uninstall and reinstall did not fix the problem. However, when the login id used in the TM1 Excel Service was changed from the Service Account to the Local Service Account the websheets worked. We (including IBM) are still trying to determine whether it is a security issue at the box’s end or a TM1 Web bug (there were no error messages when we installed TM1).