Excel macros updating other files serial dating predators list
Example: Data can only be retrieved from the last saved version of a file.
Generally, a cell is only recalculated if it contains a reference to a cell or preceding cell which has changed.
It is not long before they have a spiders web of links across multiple workbooks.
When a link updates it does not update any sub-links contained in the linked file.
For example, if Cell A1 is dragged to Cell B1, the file which links to Cell A1 will continue to link to Cell A1 (which is now the wrong cell – ooops! The risk can be mitigated slightly by using Named Ranges.
However, if it is a colleagues file, what is to stop them deleting the Named Ranges, or renaming worksheets, just because they want to (work colleagues are nice like that!