Refreshing Report: Regular report

Refreshing Report

Data refresh is required after data is changed in the source.

Regular reports enable the user to:

Refresh entire report. Execute one of the operations:

Click the Refresh button on the Home ribbon tab.
Select the Refresh All Sheets item in the drop-down menu of the Refresh button on the Home toolbar tab.
Press F9. It is available during report editing.

Refresh sheet. Select the Refresh Sheet item in the drop-down menu of the Refresh button on the Home toolbar tab.

Reopen data sources. Select the Reopen Data Sources item in the drop-down menu of the Refresh button on the Home toolbar tab. When data sources are reopened, cache of sources and their nested objects is cleared.

Automatically refresh entire regular report. Click the Automatic Refresh button on the Home toolbar tab to set up report automatic refresh.

Data sources, report data is refreshed, formulas are recalculated. All refresh settings are saved along with the regular report.

Automatic Refresh

To enable periodic report data refresh, click the Automatic Refresh button on the Home toolbar tab. Automatic refresh is set for each 5 minutes.

To change automatic refresh period, select the Set Period item in the drop-down menu of the Automatic Refresh button. The Autorefresh Period dialog box opens:

In the dialog box set automatic refresh period for report data and click the Apply button. Refresh can be executed each N seconds, minutes, or hours.

NOTE. If refresh period has been already set up for the regular report, it can be selected in the drop-down menu of the Automatic Refresh button.

The regular report is refreshed once during the specified period of time.

To disable period data refresh:

Release the Automatic Refresh button.
Deselect the checkbox next to the refresh interval in the drop-down menu of the Automatic Refresh button.

Automatic refresh of regular report is disabled.