How to update linked workbooks in Excel

excel

#1

Hi,

The manual process at the moment is to update links when opening a workbook. How can this be automated without changing the setting in the workbook to automatically update every time?

Thanks,

Pri


#2

Few different options. Personally I would ask for this to be changed to automatic but as you say you can’t do that you could do the following:

  1. Add a macro to the workbook and have it run on startup
  2. Call the same macro using UiPath once the workbook is open within an Excel Application Scope
  3. Record and repeat the exact steps that the user would take, e.g. go to links --> click update etc…

#3

@richarddenton Thanks!