Refreshing from a Ribbon

Data source types: All

In Excel, you can retrieve and refresh data for the current worksheet or for all worksheets in the workbook using the Refresh icon on the Smart View ribbon, shown in Figure 5-1.

This type of refresh action applies to entire sheets, documents and slides and includes data in all ad hoc grids and reporting objects, such as function grids, tables, or charts.

Figure 5-1 Refresh Icon

Depending on the data provider to which you are connected, the Refresh icon can either be a split button with Refresh options or a simple, one-function Refresh button.

Note:

On ad hoc sheets, Excel filters are retained after refresh.
To refresh individual reporting objects, such as function grids, tables, or charts, see Refreshing Individual Reports from Document Contents.

To use Refresh, choose an option:

To refresh the entire current worksheet, from any ribbon, click Refresh.

In Word or PowerPoint, when you click Refresh, all data points copied into the document or presentation are refreshed.

Note:

In Oracle Essbase worksheets that contain multiple grids, you can also refresh only a selected range of cells (see Multiple Grids on a Worksheet).
Oracle Business Intelligence Enterprise Edition only: To clear the contents of the entire current worksheet and replace it with the latest members and data, click the down arrow in Refresh, and then select Replace and Refresh.
To refresh all worksheets in the current workbook, click the down arrow in Refresh, and then select Refresh All Worksheets.