Converting a .xls worksheet to .xlsx

The one-time conversion of .xls worksheets results in an Open XML format Excel file that can be used in TM1® Web.

Procedure

  1. In IBM® Cognos® TM1 Architect Server Explorer, right-click the worksheet or folder you want to convert. Only Microsoft Excel .xls files will be converted regardless of other files that may be in the folder.
  2. Select Convert Excel file to OpenXML format.
  3. By default a backup of the pre-converted .xls file and a log is created in the directory locations displayed. You can browse to identify new locations for these files, if you prefer.
  4. When the conversion is completed, the window lists the number of files found and completed and the location of the log text file that was generated.
  5. You may need to re-establish links to some files or action buttons. The change to cell-based security means some files may not have the correct permissions to work without some manual adjustments.
Parent topic: Microsoft Excel .xls worksheets