Excel refreshing table un-hides columns and changes active worksheet
I have a simple macro that refreshes a few tables generated by Power Query. The whole thing takes 5 seconds. When the tables refresh, however, all their columns become un-hidden and the active worksheet changes. Adding steps to the macro does not work. The refreshing always supersedes whatever final steps I add.
Table properties have "Adjust column width" unchecked.
Application.ScreenUpdating = False.
Background Refresh = False.
DoEvents is present, and within a "Do While" loop to try to force these tables to finish refreshing. Nothing works. Please help.
All the trouble started when I upgraded to 64-bit Excel 2016.