Naturally, that means that Excel won’t auto-fill the formula, as it doesn’t know which is correct (the formulas or the blank cell.) We need to fix that before this will work for us. And if your behavior is different, I’d love to know.
Our data should now look something like this: And now, when we add new data and refresh the Power Query… I’m running the Office Pro Plus subscription – first release.
On Excel 2010/2013, the old default of not updating the tables appears to prevail.
It’s actually for this reason that I covered this, as it came up as a question in my Power Query forum.
When you apply a formula to a cell in Excel, it automatically updates the values when you click out of the cell after entering a value. Sometimes, the calculation is configured to “manual” and this is the primary cause of cells not updating in excel. Launch Excel and go to Tools and then head over to Options.