then uploaded both files to Share Point Scenario 2: User created MS Excel files on the desktop, linked those files (desktop or shared drive).then uploaded only container file to Share Point Scenario 3: User created MS Excel files on the desktop, linked those files (desktop or shared drive).Nice work with the data report, but not nicely executed.
then uploaded both files to Share Point and updated the linked files using their Share Point links Scenario 2 is common among Excel users.
Users create linked excel files and upload only the main file aka the container file.
In most cases the linked file was on the desktop of the user.
Now when another user tries to open the Excel container file from Share Point or from their desktop by copying it, they get errors / warning messages.
In Edit Links window, if you select a source, you will see its location.
In situations, you will find it pointing to the local desktop profile of users.With Excel files being regularly emailed around and with the ease with which you can link excel spreadsheets (and then send only one of the linked spreadsheets), a frequent question is how to stop excel from asking to update links.By default if Excel sees that there are links in a spreadsheet it provides a warning that there is external content and then will ask what it must do with the links.Take a look at the chart series and the pivottable source ranges.Tactic 5 A few macros: Sub Delete Links() 'thanks Hans Herber Dim var Link As Variant, int Counter As Integer var Link = Active Workbook.There are few scenarios where the linked files can cause issues if not used properly.