How can I update my Excel BI Tools to the latest file type versions, xlsx or xlsm?

To change a BI tool with macros from the xls file type to xlsm, follow the following steps:

  1. 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.
  2. 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.