Refreshing Data

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

Refreshing applies to entire current sheet, and includes data in forms, ad hoc grids, and functions.

In the Extensions menu, select Smart View for Google Workspace, and then select Refresh to refresh the current sheet.

Alternatively, you can also use the Refresh option available in the Favorites menu. Refreshing is also part of some specific actions, such as the Refresh button in the POV panel that is used to refresh the sheet after changing the POV.

Notes about Refreshing

  • If you have multiple sheets in your spreadsheet, open each sheet and click Refresh to refresh them separately. Refreshing all sheets in a spreadsheet at the same time is not supported.
  • On ad hoc sheets, Google Sheets 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.
  • When working with multiple grids from multiple data sources in the same sheet, you can refresh grid data for all connections at the same time.

    For example, you are working on a sheet with Grid 1 and Grid 2 connected to Planning and Grid 3 connected to Tax Reporting. When you click Refresh from the Smart View for Google Workspace menu, all grids—Grid 1, Grid 2, and Grid 3—are refreshed at the same time in a single operation.

    • To refresh all grids together, select any cell outside the ranges of the grids and click Refresh.
    • To refresh only a particular grid, select any cell within the range of the grid and click Refresh. This is saves the time taken to refresh data, especially when the sheet contains a lot of grids.
  • If support for Google Sheets is not enabled and, after connecting to a data source from Smart View, you reopen a saved sheet and try to refresh or submit the saved sheet, update and submit data in grids, or refresh functions in the sheet, a message appears stating "This operation is not supported by the provider. Contact your Administrator to enable support for Google Sheets". You cannot proceed further with submitting or refreshing data, unless the support for Google Sheets is enabled by your Service Administrator.

  • Refreshing a form or ad hoc grid from the POV panel or the Favorites panel refreshes the sheet but not the cell value that has been edited and kept in edit mode.

    For example, in a form or ad hoc grid, you edit a data value, keep the cell in edit mode, and then change the POV from the POV panel. When you click Refresh in the POV panel, the sheet refreshes to display the data as per the changed POV, but the cell in edit mode does not refresh. It continues to display the value as per the earlier POV.