Forum Discussion
Chart updates inconsistently when dynamic array resizes
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically res...
Went to the DATA tab and saw that the pivot table was not set to "Auto Refresh". Most likely because your Excel doesn't support it
Correct, that's why I asked Insiders to check this works with the upcoming Auto Refresh functionality
It seems the UI tab is protected
Forgot to remove it before attaching the file so apologies for the inconvenience
Removed the protection and everything refreshes automatically upon changing the TOPN number in the UI tab
Perfect & Thanks much Riny
(cc: Anonymous29007​)