Excel button to refresh data

Options

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:

Answers

  • Cbrack
    Cbrack Member
    Options

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

  • ArborRose
    Options

    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.

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

    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.

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