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.