Cognos TM1 10.2.0 FP1 - Troubleshooting the .xls to .xlsx conversion process and issues with action buttons being re-sized in TM1 Architect and TM1 Perspectives
In IBM® Cognos® TM1® 10.2.0 Fix Pack 1 (FP1) the TM1 .xls to .xlsx conversion feature available in TM1 Architect and TM1 Perspectives has been updated to address a problem with action buttons getting larger (re-sized) within the Microsoft Excel environment. This document summarizes some related information and troubleshooting around this process.
If you have action buttons that appear to grow larger after opening the worksheet in Excel, even if the worksheet has already been converted to the OpenXML format (a .xlsx or .xlsm file), you can re-run the conversion program on that file and it will attempt to address the action button sizing issue.
Note that if you have already re-saved a worksheet with action buttons that had become enlarged, then the new size is saved and Cognos TM1 is not be able to restore them to the original size.
Whenever a worksheet has been updated by the TM1 conversion program, the worksheet file name (not the display name) gets updated. If you have TM1 Web open before converting, the links in the navigation pane will point to the older files, causing a file not found issue. To correct this issue, refresh the TM1 Web navigation tree using the refresh icon.