Updating links in excel 2016
When you create external references (also called links), you can control whether the external references stay up to date, and when they are updated.
Break a link to a source Important When you break a link to a source, all formulas that use the source are converted to their current value.
Overview: I have a worksheet that acts to aggregate a bunch of data from a number of additional workbooks, and when I'm adding a new column of data I generally copy a previously linked column and then do a find and replace to get the different dataset from the same columns (i.e.
in the first column I'm pulling in named cell from each workbook) The issue is, that I don't have just one workbook that does this, I have many and have to build new ones regularly and when I copy and paste a linked file Excel lags as it pastes in the new column and I guess starts linking to the workbooks.
You can also easily change the source workbook in an external reference.
For example, the source workbook may have been moved and you need to update the external reference to reflect the change.