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 10, Refresh Icon.
In Essbase worksheets that contain multiple grids, you can also refresh only a selected range of cells (see Multiple Grids on a Worksheet).
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.
Oracle BI EE 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.
Note:
The Replace and Refresh option does not apply to Oracle Planning and Budgeting Cloud Service.
To refresh all worksheets in the current workbook, click the down arrow in Refresh, and then select Refresh All Worksheets.