Buzz
Microsoft is initiating support for Workbook Link on Excel for the web. When gathering data from multiple Workbooks, you often want to link them directly to the data. This provides a record of where the data is sourced from, and if the data changes, you can easily refresh it. This has made Workbook Link support a highly requested feature for web users.
Download and Install the Latest Version of Excel:
To create a new Workbook Link, simply copy a portion from the source spreadsheet and paste the link into the destination sheet using the Paste Option. Both spreadsheets must be created in Excel for the web and saved on OneDrive or SharePoint for the new feature to work.
- Learn more: How to Use Excel Online
Users can manage links from Workbook Links under the Data tab in the Ribbon. The list below provides options to view all active links and allows users to refresh or remove multiple links at once, or perform individual actions on each link. The list also indicates the status of the links. If a link is not updated, the status will notify the user and even provide the reason for any errors if possible.
When users open an Excel file with external links, a yellow banner will appear with the Enable Content option, similar to desktop versions. Dismissing or removing the prompt will prevent the file from updating data from those external links. Finally, Microsoft states that direct links to external Workbooks were previously simply referred to as External Links. As they continuously add external data sources to Excel, the term External Links has become vague. Therefore, to increase clarity in the future, the company will use the term Workbook Links to replace it.
Support for Workbook Links is currently being rolled out to all users on the web. Since the deployment process is gradual, this feature may not appear immediately for everyone.
After the tech news, users can visit Computer Tips on Mytour to follow many experiences and handy tips when using PC, Laptop, and installing software.
