Can we perform Refresh operation on excel file?

I have excel operation where i need to perform Refresh operation on it? Is it possible to perform Refresh using Ui-Path on excel or is there any workaround for this?

Regards,
Ahtesham

I have done this by running Excel macro from uipath. In Excel you can record / create vba code easily.

Hope it helps :slight_smile:

Hi @md.ahtesham,
To refresh or recalculate in Excel (when using the F9 for The Financial Edge), you normally can use the following keys:

  • To refresh the current cell - press F2 + Enter
  • To refresh the current tab - press Shift + F9
  • To refresh the entire workbook - press F9

If you have any issues with the above option refreshing, please try:

CTRL+ALT+SHIFT+F9

as per the below article:
https://kb.blackbaud.co.uk/articles/Article/49534

Here is some link to a similar discussion, where VBA script was discussed:

And perhaps this will be of some use:

does this help? :slight_smile: