1. Extensions
  2. Google Sheets Add-on
  3. Work with Anaplan model data in Google Sheets
  4. Change page selection

The Google Sheets Add-on enables you to change page selection in your worksheet, just as you would in Anaplan.

In Anaplan, page selectors enable you to include more dimensions in a grid than you can display with rows and columns alone. You can select different items in page selectors to change the data that displays. 

Make sure you are in a Google spreadsheet that is connected to an Anaplan module.

When you change page selection, the connection refreshes with the latest data from Anaplan. Anaplan data replaces any edits you've made.

If you have a read-write connection you can send and refresh your worksheet before you change page selection. Send and refresh updates Anaplan with any edits you've made, so these are not lost when you change page selection.

The page selectors display in the Anaplan sidebar:

A worksheet with the Anaplan menu open in the side bar. The Pages section is highlighted, showing page selectors for Versions. The page selected, Budget, displays in blue.

To change the dimensions that display in a Google worksheet:

  1. In the Anaplan sidebar, click the arrow next to the dimension you want to change.
    The Pages menu opens.
    The current dimension displays in a drop-down menu.
    The pages for that dimension display beneath, with the current selection highlighted in blue.
A worksheet with the Pages menu open in the side bar. Underneath Pages is a drop-down menu with the current page selected. Beneath the drop-down menu is a list of the dimensions available for that page. Budget is highlighted in blue.
  1. Optionally, select a different dimension from the drop-down menu.
    The pages for the selected dimension display.
    You may swap back and forth between the dimensions and select new pages for each. All changes you make update when you refresh at the end of the procedure.
A worksheet displays with the Pages menu open. A different dimension has been selected in the drop-down menu and different pages show beneath.
  1. Select the page you want to use. To find the page, either:
  • select from the list displayed, or
  • enter the name of the dimension item in the search field.
    Any item that matches your search criteria displays and you can select the page you want to use.
A worksheet with the Pages menu open. Digital has been entered in the search field. Two pages named Digital display in a list beneath, along with the pages above them in the hierarchy.
  1. Click Refresh.
    The data in the current sheet refreshes and you're returned to the Anaplan sidebar. The connection description and Anaplan sidebar update to show your selected dimension.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.