Data source types: all
In Excel, you can retrieve and refresh data for the current worksheet or for all worksheets in the workbook. In Essbase worksheets that contain multiple grids, you can also refresh only a selected range of cells (see Multiple Grids on a Worksheet).
To refresh the entire current worksheet, from any ribbon, click Refresh.
To refresh all worksheets in the current workbook, click the arrow next to Refresh, and then select Refresh All Worksheets.
In Word or PowerPoint, when you click Refresh, all data points copied into the document or presentation are refreshed.