Excel refreshing table un-hides columns and changes active worksheet

Jon Payne 1 Reputation point
2021-01-25T21:19:22.627+00:00

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.

{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.