Create a Static Copy

When using the SEI Add-in for Excel with SEI Formulas, the data is only displayed when connected to the SEI Central Point and to the actual database.

This might be an issue when sending an Excel Report obtained using SEI Formulas to a colleague that is not connected to the database or when the user travels and would like the report kept in the Excel format.

To make it possible to use the Excel report without being connected to the database, the SEI Add-in for Excel enables you to save a static copy by using the Create Static Copy menu option in the Excel Add-in tab.

The Static Copy will only save the values of the cells, and not the formulas, enabling the use of the Excel report while not connected to the database.

  1. Click on Create Static Copy in the Excel Add-in tab.
  2. Select as required:
    • Entire Workbook or Active Sheet
    • Open the document after the copy
    • Send the document by email
  1. Click on Copy to create the copy.