You can also copy-paste the following line into the address bar in Registry Editor, assuming you’ve updated to the Creators Update. If you don’t feel like diving into the registry yourself, we’ve created two downloadable registry hacks you can use.
One enables this option, preventing Windows Update from automatically installing driver updates.
Important: When you break a link to a source, all formulas that use the source are converted to their current value. When you replace a formula with its value, Excel permanently removes the formula.
If you accidentally replace a formula with a value and you want to restore the formula, click Undo immediately after you enter or paste the value. If the data does not need to be the most current, you can save time by not updating all of the links.
It’s a pretty powerful tool, so if you’ve never used it before, it’s worth taking some time to learn what it can do.
Also, if you’re on a company network, do everyone a favor and check with your admin first.
After opening the workbook, on the Data tab, in the Connections group, click Edit Links, and then update the links only from the sources that you need.
In the Registry Editor, navigate to the following key in the left sidebar.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.Driver updates may be bundled with security updates or feature updates, according to Microsoft’s documentation.On Windows 10 Home, you can only change this option via the Registry.