To change a BI tool with macros from the xls file type to xlsm, follow the following steps:
- Go to the main menu, select the Prepare option, and then select the Encrypt Document option. Doing this opens a dialogue box with a secret password. Proceed to delete this password and click ok.
- Go to the main menu again, select the “Save As” option, and then the “Excel Macro-Enabled Workbook” option.
To change a BI tool without macros from the xls file type to xlsx, go to the main menu, select the “Save As” option, and then the “Excel Workbook” option.