Cells not updating in excel 2016

11-Dec-2019 16:13

The reason the formulas didn’t fill correctly for us is different now.It is entirely based on the fact the formula in the last column is no longer consistent.

In fact, even refreshing the table seems to make no difference.I’ve worked with this issue for a long time, and it’s actually caused me to avoid using Excel formulas in tables generated via Power Query all together.Having said that, there is now an easy way to fix this which renders that avoidance obsolete. We have a simple table called Animals as follows: And it gets landed in another table.As ever, when you work in IT you become the go to guy / gal for friends, family etc…So today, whilst working on my Tech Ed Europe 2012 presentation, my girlfriend rang up, asked if I knew Excel and promptly forward me to a manager for a quick chat.

In fact, even refreshing the table seems to make no difference.

I’ve worked with this issue for a long time, and it’s actually caused me to avoid using Excel formulas in tables generated via Power Query all together.

Having said that, there is now an easy way to fix this which renders that avoidance obsolete. We have a simple table called Animals as follows: And it gets landed in another table.

As ever, when you work in IT you become the go to guy / gal for friends, family etc…

So today, whilst working on my Tech Ed Europe 2012 presentation, my girlfriend rang up, asked if I knew Excel and promptly forward me to a manager for a quick chat.

The default setting in Excel 2013 causes your formulas to update automatically, so you are probably accustomed to changing values in cells as needed, without considering that Excel may not be automatically updating related formula cells.