AX2796

Refreshing a report with data

To update a spreadsheet Axiom 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:

• On the Axiom tab, in the File Options group, click Refresh.

  This refreshes all sheets in the workbook. If you want to refresh the current sheet only, click the down arrow on the right-hand side of the Refresh button, and then click Refresh Active Sheet.

  In systems with installed products, this feature may be located on the Main tab.

You may be prompted to define values before the refresh occurs. If so, these values will be applied to the report to impact the data refresh.

TIP: You can also use F9 to refresh the entire workbook, and SHIFT+F9 to refresh only the active sheet.