EXCEL external link workbook

[DjabiaK]

Hello, 

Any advice on how to make a link work on excel workbook? 

What will be the best step to follow to make it work so that any time one file is updated, it will also update the second file . I copy the data from one file and paste it as a link . I set up the file working on 365 office app excel but when uploaded in SharePoint to share it with other member, it does not seem to be working 

[#2 · Accepted solution]

@DjabiaK 

When working with Excel for the web and external links to other workbooks, there are a few things to consider to ensure the links work correctly:

1. Store the workbooks in a shared location: Both the source workbook (the one containing the data) and the destination workbook (where the data will be linked) should be stored in a shared location, such as SharePoint or OneDrive. This ensures that all users have access to the files.
2. Use valid file paths: When creating the links, make sure to use valid file paths that correctly reference the location of the source workbook. If the file is stored in SharePoint, the link should typically start with https:// followed by the SharePoint site URL and the path to the file. To create a hyperlink that works in Excel for the web and links to another workbook stored in SharePoint, the hyperlink address should follow the format of the SharePoint URL combined with the relative path to the file. Here's an example of what the hyperlink address might look like: 

https://your-sharepoint-site-name/sites/your-site-name/Shared%20Documents/Your%20Folder/YourWorkbook.xlsx​

• Verify the link addresses: Double-check that the link addresses are accurate and haven't changed. If any changes are made to the file names or paths, the links may break. It's best to use relative paths whenever possible, as they are more resilient to changes in file locations.
• Enable automatic calculation and data refresh: Ensure that automatic calculation and data refresh are enabled in both the source and destination workbooks. This allows the linked data to be updated automatically when changes are made to the source workbook. In Excel for the web, automatic calculation and data refresh are typically enabled by default.
• Refresh the data: When you open the destination workbook or want to update the linked data manually, you may need to refresh the data. In Excel for the web, you can click the "Refresh" button or use the "Refresh All" option to update all the linked data in the workbook.

Please note that the functionality and behavior of external links may vary depending on the specific version of Excel for the web and SharePoint being used. It's always a good idea to refer to the documentation or support resources provided by Microsoft for more detailed information on working with external links in your specific environment.

[#3]

@NikolinoDE Thank You so much 

I think it worked. Thank You for the detail approach and information.