At long last, we have confirmation that the Cache Shared Nodes Fix is live in Excel. If you're not familiar with this issue, it's one of the most important changes implemented in Power Query in quite some time. You can read more about the issue in my guest post on Rob Collie's blog here.
What versions of Excel will get the Cache Shared Nodes Fix?
The Cache Shared Nodes fix is available to:
- Office 365 subscribers
- Excel 2019 (non-subscription) versions
This leaves you with the inefficient multi-refresh challenge if you are using Excel 2010, Excel 2013 or Excel 2016. My understanding is that Microsoft does not intend to back port to these versions. What that means to you is that in in order to get the fix, you will need to upgrade to a newer version.
Do I have the Cache Shared Nodes Fix?
You need to be running Excel 16.0.10726.* to have the update. To check if you have it, go to File --> Account --> About Excel. Your current version and build are listed at the top:
Office 365 Insider's Build
How do I update my Excel 365/2019 to get the Cache Shared Nodes Fix?
For users of Excel 2019, make sure your Windows Update settings include the advanced option to get updates for other Microsoft Software. If your version is not updated yet, it should come through on your next update cycle.
For users of Office 365, you should actually already have the fix in place. If not, go to File --> Account --> Update Options.
(There is a possible exception for Office 365 if you're running on the Deferred Channel for updates. If that's the case, you either need to get onto a more current channel, or... wait until the deferred channel also has the fix.)