Skip to content

Use Excel shell templates

An Excel shell template runs a Nexsyis report inside Excel. Enter the connection details and report parameters once, then refresh the report whenever you need current data.

  1. Open the Excel report and make sure all macros are enabled.

    The report title fills in automatically in cell A1.

  2. On the Parameters worksheet, enter your Server Name and Database in the green cells.

  3. In the Clear Data on Save green cell, enter Y to clear all the report data automatically when you save the file, or N to keep it.

  4. Enter any other parameters the report needs, for example a beginning and ending date.

  5. Select Refresh to run the report. The Refresh button is always at the top of the report.

An Excel shell template with the Refresh button and the Server Name, Database, Clear Data on Save and date parameter cells

Save the updated reports on your network, in your reports or templates folder.