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.
In the Registry Editor, navigate to the following key in the left sidebar.
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.