Quote:Microsoft today announced that it is bringing Workbook Links to Excel on the web. The firm says that it aims to let customers also use the web client for all their work, without having to “fall back to the rich client”. The feature lets users paste direct links to data from other workbooks, just like on Excel for Windows and Mac.
 
The feature is as simple as copying a range from a source table and pasting the link via the ‘Paste Options’. Both spreadsheets must be created on the web version and should be saved in OneDrive or SharePoint for the feature to work. The firm adds that the feature has been highly requested and that it helps users keep a record of the data source and easily refresh it.
 

Users can manage links from ‘Workbook Links’ under the Data tab in the ribbon. The list under the option shows all active links and provides users with the ability to refresh or break them at once, or action each link separately. The list will also display the status of the links. If a link has not been updated, the status notifies the user and even provides a reason for the error, if possible. [...]