Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Opening OfficeConnect File In Excel

Question

How do you open an OfficeConnect file in Excel?

Answer

There are two options to open or save an OfficeConnect file (with the extension .xlsxai) in Excel to allow users without OfficeConnect installed to see the information

NOTE: The options below will convert all data to hard-coded values/formulas when viewing from Excel. If there is any data in the OfficeConnect file you do not want shown when viewing from Excel you will need to remove this before you proceed with options 1 or 2 below.

Option 1. With OfficeConnect Excel running go to File>OfficeConnect>Export Workbook and save the file.

  • This will save it as a regular Excel file (with the extension .xlsx) that anyone can open with Excel
  • In the new file saved as .xlsx there will no longer be metadata or access restrictions.

                  

Option 2. Save the file in OfficeConnect as you regularly would (clearing data if needed) and open the saved OfficeConnect file in Excel

  • A warning will show up saying you are opening a file in a different format than expected, asking "Do you want to open the file now?"

  • Clicking "Yes" will display the file in Excel without metadata or access restrictions

  • Was this article helpful?