IBM Support

Excel sheets with a dot in the name do not render properly in TM1Web

Question & Answer


Question

Excel sheets with a dot in the name do not render properly in TM1Web

Cause

If you see no Data on the sheet or formatting missing or #ERR on cells where data is expected to be seen, this is because of the sheet name. The same sheet will work as expected in Planning Analytics for Excel. 

Answer

This is a limitation within TM1web. Don't name or start tab names with a '.'

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m3p000000PC7hAAG","label":"Planning Analytics-\u003EWeb PASS Contributor Application-\u003EModel and Reporting"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
01 March 2024

UID

ibm17129261