Use the Get workbook links action allows users to retrieve all external workbook links from an Excel.

Note: This action is currently supported for only the Excel automations running on macOS platform.

Managing workbook links is essential for maintaining data integrity. With the introduction of this action, any possible inefficient screen recordings are now replaced with reliable, native solution for identifying linked workbooks in Excel files.

Considerations

An error is displayed if one of the following conditions are encountered when you deploy your automation to get workbook links in a Microsoft Excel file:
  • The session name that you have specified is invalid or does not exist.
  • If the workbook that you have specified does not have any source workbook links.

Settings

  • Use the Session name field to select one of the following tabs to specify the name of the Excel session provided using the Open action:
    • Session name: Enter the name you gave the session when you opened it. You can also click the Insert a value icon to select a variable or global value that you have used to store the Excel session name.
    • Variable: Select an existing variable that you have used to store the Excel session name.
  • Click the Assign the output to variable drop-down menu to select an existing variable to store the number of workbook links successfully retrieved.

    (Optional) Click the Create variable icon if you want to create a variable.

    .