Skip to main content
Solved

Office 365 Excel execution of toolbar functions

  • Oct 28, 2026 12:25 PM UTC
  • 4 replies
  • 41 views

Forum|alt.badge.img

Hello. The Office 365 Excel package appears to be an API package, which means when it runs you will not ‘see’ the spreadsheet (and of course you also then won’t see Excel toolbar functions).

 

With the Office 365 Excel package, are you able to initiate functions you would see in the Excel toolbar? In particular, I’m needing to initiate a ‘refresh all’ command. Is that able to be done with the Office 365 Excel package? Or do I need to manipulate the spreadsheet via a browser window or via a desktop version of Excel?

 

Thanks.

Best answer by devendeshpande

In my opinion, the most reliable would be:

  • Use the Browser Package or Web Automation package to:
    • Open the file in Excel Online via browser.
    • Navigate to the Data tab.
    • Click the Refresh All button using UI automation.
  • This mimics a user clicking the toolbar button.
View original

4 replies

Forum|alt.badge.img
  • Automation Anywhere Team
  • Answer
  • Oct 30, 2026 4:18 AM UTC

In my opinion, the most reliable would be:

  • Use the Browser Package or Web Automation package to:
    • Open the file in Excel Online via browser.
    • Navigate to the Data tab.
    • Click the Refresh All button using UI automation.
  • This mimics a user clicking the toolbar button.

Shreya.Kumar
Pathfinder Community Team
Forum|alt.badge.img+4

​@Chris 7034 , did you try the workaround that Deven suggested? Alternatively, you could also convert your excel rows and columns to Tables, and then they would refresh automatically. 


Forum|alt.badge.img
  • Author
  • Cadet | Tier 2
  • Nov 3, 2026 2:48 PM UTC

Thanks for the replies and sorry for the delayed response. My original question was mostly to see if functionality existed within the 365 Excel package to do the refresh I need. Sounds like that is not available currently.

I can certainly use a browser-based ‘refresh all’ or even a desktop ‘refresh’ function, and that is indeed my backup plan. My case is a little different perhaps...I’m pulling data into Excel from a datalake via some SQL I wrote. I don’t want to set ‘refresh automatically’ on the spreadsheet so I need a manual ‘refresh’ to tell Excel to rerun the query through the data connection.

Thanks again to you both. And Shreya...nice to hear from you, I’ve seen you on quite a few webcasts in the past. :)


Shreya.Kumar
Pathfinder Community Team
Forum|alt.badge.img+4

Thanks for the replies and sorry for the delayed response. My original question was mostly to see if functionality existed within the 365 Excel package to do the refresh I need. Sounds like that is not available currently.

I can certainly use a browser-based ‘refresh all’ or even a desktop ‘refresh’ function, and that is indeed my backup plan. My case is a little different perhaps...I’m pulling data into Excel from a datalake via some SQL I wrote. I don’t want to set ‘refresh automatically’ on the spreadsheet so I need a manual ‘refresh’ to tell Excel to rerun the query through the data connection.

Thanks again to you both. And Shreya...nice to hear from you, I’ve seen you on quite a few webcasts in the past. :)

nice to hear from you as well, CHris.

we’ve flagged the missing functionality for our Product team. Meanwhile, will keep an eye out for a workaround!