IBM Support

TM1 Web cannot open XLSX-files as websheets

Troubleshooting


Problem

You cannot open XLSX-files as a websheet in the web browser although Microsoft Excel 2007 is installed on the TM1 Web Server computer. But you can open XLS-files as a websheet in the web browser. When you try to open a XLSX-file as a websheet in the web browser, a second XLSX-suffix is added to the filename of your XLSX-file, converting the real filename '.xlsx' into '.xlsx.xlsx'. Depending on how often you tried to open the XLSX-file as a websheet, a number will be displayed in square brackets after the first XLSX-suffix in the converted filename of your XLSX-file, for instance ".xlsx[5].xlsx".

Symptom

When you try to open a XLSX-file as a websheet in the MSIE web browser you are prompted with the MSIE File Download dialog box:

File Download
Do you want to open or save this file ?
Name: <filename>.xlsx.xlsx
Type: Microsoft Office Excel 2007 Workbook, xxx KB
From: <hostname>
Buttons: "Open", "Save", "Cancel"


The corresponding german MSIE File Download dialog box is:

Dateidownload
Möchten Sie diese Datei öffnen oder speichern ?
Name: <filename>.xlsx.xlsx
Typ: Microsoft Office Excel 2007 Arbeitsmappe, xxx KB
Von: <hostname>
Buttons: "Öffnen", "Speichern", "Abbrechen"


When you click the Button "Open" Excel 2007 will start and open your XLSX-file in three steps:

(1)
To open your XLSX-file will return the english Excel error message:

Microsoft Excel
Excel found unreadable content in '<filename>.xlsx.xlsx'. Do you want to recover the contents from this workbook? If you trust the source of this workbook choose 'Yes'.
Buttons: "Yes", "No"


The corresponding german Excel error message is:

Microsoft Excel
Von Excel wurde unlesbarer Inhalt in '<filename>.xlsx.xlsx' gefunden. Möchten Sie den Inhalt dieser Arbeitsmappe wiederherstellen? Wenn Sie der Quelle dieser Arbeitsmappe vertrauen, klicken Sie auf 'Ja'.
Buttons: "Ja", "Nein"


(2)
When you click the Button "Yes" Excel 2007 will return a repair message:

Repairs to '<filename>.xlsx.xlsx'
Excel was able to open the file by repairing or removing the unreadable content.
Excel completed file level validation and repair. Some parts of the workbook may have been repaired or discarded.
Button: "Close"


The corrresponding german repair message is:

Reparaturen in '<filename>.xlsx.xlsx'
Die Datei konnte von Excel geöffnet werden, indem der nicht lesbare Inhalt repariert oder entfernt wurde.
Excel hat die Überprüfung und Reparatur auf Dateiebene abgeschlossen. Einige Teile dieser Arbeitsmappe wurden repariert oder verworfen.
Button: "Schliessen"


(3)
When you click the Button "Close" Excel 2007 will open your XLSX-file.


Note:
Excel 2007 will only start when you use the MSIE web browser on your TM1 Web Server computer or when Excel 2007 is locally installed on your remote TM1 Web Client computer.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;9.5.1;9.5;9.4 MR1;9.4","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSDL22","label":"IBM Planning Analytics Express"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 May 2025

UID

swg21508527