Refreshing a report with data

To update a report with the most current data from the database, refresh the file. A refresh does the following:

  • Updates active Axiom queries with data, according to the update settings defined for the query.
  • Updates Axiom functions with data.
  • Performs an Excel calculation.
  • Reapplies the currently active views (if applicable).

To refresh a report with data:

Do one of the following:

  • On the Main ribbon tab, in the Workbook Options group, click Refresh Data.

  • Press F9.

The system may prompt you to define values before the refresh occurs. If so, the system applies these values to the report to affect the data refresh.