Skip to main content
Veteran
February 10, 2023

Excel Addin TIP: To customize your OneStream Ribbon - Separate button Save Worksheet and Refresh

  • February 10, 2023
  • 3 replies
  • 0 views

How to customize the OneStream Excel Addin Ribbon.

NicolasArgente_0-1676028742070.png

 

 

  • In Excel, go to File > Options
  • Select Customize Ribbon
  • Select Main
  • Select the OneStream Tab on the left – that is the source of all the buttons
  • Select the Onestream Ribbon on the right – that is your target customization
  • Move the buttons you need from left to right. You can create groups for your menu too.

 

If you want to separate the Save and Refresh, you first need to Remove it and then recreate it. Like shown in the screen above. You can then create a ribbon like below where I separated the Data Refresh vs Data Save. Unfortunately each user has to do that.

NicolasArgente_1-1676028742071.png

 

3 replies

OneStream Employee
February 10, 2023

Thanks Nicolas, great tip!

aricgresko
Veteran
February 10, 2023

This is awesome! I also like to put the Refresh Sheet button on the Quick Access Toolbar in the first position to ALT + 1 to refresh the sheet.

Contributor
May 3, 2023

This is very helpful! Wish we could do this in OneStream with the save and revert changes buttons 😂