1. Working with Oracle Smart View for Office (Mac and Browser)
  2. Data and Data Cells
  3. Refreshing Data

Refreshing Data

You can retrieve and refresh data for the current sheet in the workbook.

Refreshing applies to entire sheets, and includes data in all ad hoc grids and reporting objects, such as function grids, tables, or charts.

In the provider or Smart View ribbon, click Refresh to refresh the current sheet.

Figure 8-1 Refresh Icon

Refresh button

Notes about Refreshing

  • On ad hoc sheets, Excel filters are retained after refreshing.
  • Selected POV members are reverted to dimension members after deleting some columns and refreshing a sheet. To avoid this, click the POV button to hide the POV dimensions, and ensure that you do not delete the column that contains the Page members.