Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

The Planning Tab in Excel's Ribbon

Describes the function of each button on the Planning tab ribbon of Excel Interface for Planning.

Contains preview content for the upcoming 2018.1 release.

The Planning tab appears in the Excel ribbon after you have installed  Excel Interface for Planning .  This page explains the toolbar's buttons and their functions.  

Excel ribbon with the Planning Tab open.

Planning Tab Buttons

 logout2.png Log in to connect to the Adaptive server: access your sheets, refresh the data displayed in Excel  and update the server with modifications you've made in Excel.
Log out to work offline.  You modifications are not saved to the server until you log in again and submit. 
refresheip.png Click to pull in any new data that has been entered by other users since you were last connected. If there are conflicts between the new data and your data, you'll be asked to resolve it. 
Click to save your work to the sheets on the Adaptive server. 
Click to refresh the Planning pane with the most current  sheets, levels, and assumptions.
  Add and delete rows in certain sheets.
Add splits to create subcategories for selected rows.  The value rolls up to the original row, which will no longer be editable for you. 
 
delete splits.png renameSplits.png Delete and rename splits you've created. 
display options.png

Filter data displayed on the Grid or compare up to 3 versions on the same Grid (for example, last year's actuals, last year's budget and today's working budget).

FilterSheet.png For modeled sheets only. Filter columns by content, using operators such as begins with, ends with, and so on. 

Preference Toggles

preferences.png

  • Preserve local formatting to save formatting changes you've made  to the sheet in Adaptive Planning when you click Submit.
  • Group accounts so you can expand and collapse the  rows according to your company's organization outline within Adaptive. 
  • Show (or hide ) the Planning panel to view more of the Grid.  
Link to Adaptive Insights and log in to the Adaptive Suite of products available to you.  Link to contextual help articles, like this one.