Excel button to refresh data

Cbrack
Cbrack Member
in Software Integrations

Hello,

I have 2 questions.

  1. what is "live data mode" in the Excel O365 add-in?
  2. Is there a way to create an Excel button which calls Domo Data Refresh all, instead of using the file menu at the top to refresh the data?

Thanks for the help.

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    Live Data Mode refers to the capability of the Domo add-in to pull the most recent data from Domo into your Excel spreadsheet. When this mode is enabled, the data in Excel is dynamically linked to your Domo datasets, ensuring that you are always working with the latest available data.

    You may be able to creat a button using VBA. In the developer tab in Excel….go to File > Options. Select customize ribbon. Check the developer checkbox and ok.

    image.png
    image.png

    Draw the button on your screen by clicking on a cell area and dragging.

    image.png

    Right click on the button and select Assign Macro. Give it a name such as RefreshDomoData. A VBA editor will popup. Write a script to refresh the Domo data. Domo doesn't provide a direct VBA api for refreshing, but you can possibly simulate a refresh by interacting with the add-in's refresh function.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • Cbrack
    Cbrack Member

    Hello, just checking if there is anyone who has experience with this? Thanks

  • ArborRose
    ArborRose Coach
    Answer ✓

    Live Data Mode refers to the capability of the Domo add-in to pull the most recent data from Domo into your Excel spreadsheet. When this mode is enabled, the data in Excel is dynamically linked to your Domo datasets, ensuring that you are always working with the latest available data.

    You may be able to creat a button using VBA. In the developer tab in Excel….go to File > Options. Select customize ribbon. Check the developer checkbox and ok.

    image.png
    image.png

    Draw the button on your screen by clicking on a cell area and dragging.

    image.png

    Right click on the button and select Assign Macro. Give it a name such as RefreshDomoData. A VBA editor will popup. Write a script to refresh the Domo data. Domo doesn't provide a direct VBA api for refreshing, but you can possibly simulate a refresh by interacting with the add-in's refresh function.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Cbrack
    Cbrack Member

    Great. Thank you so much for the help. I'll give this a try

Categories