The workbook that contains the links is called the destination workbook, and the workbook that is linked to it is called the source workbook.
If the workbook that you have opened (called a destination file) contains links to other workbooks or files (called source files), and the source files have changed, the links in the workbook that you are opening may display information that is out of date. The destination workbook contains the external reference. The external reference (or link) is a reference to a cell range in the source workbook. The source workbook contains the cell and the actual value that is retrieved and placed in the destination workbook.
Don't prompt for all workbooks I open, and update the links automatically This option affects every workbook opened on the computer.
Users who open the workbook on another computer are not affected.
On Windows 10 Home, you can only change this option via the Registry.The “Disable Automatic Driver Updates” hack adds the value to your Registry, and the “Enable Automatic Driver Updates” file deletes it.You can right-click any file and select “Edit” to see exactly what they do.The other disables this option, restoring the default behavior. Double-click the one you want to use, agree to add its data to your Registry, and then restart your PC.Disable Automatic Driver Updates Hacks RELATED: These hacks just change the setting we covered above.