admin管理员组

文章数量:1516870

I'm seeing you can use macros to run to refresh everything but I need to find a way when I press REFRESH ALL that it updates all charts and pivots also.

Is there a way to run the macro when you press REFRESH ALL so that when data changes the pivots and charts are automatically updated without having to activate the macro itself? Thanks.

I'm seeing you can use macros to run to refresh everything but I need to find a way when I press REFRESH ALL that it updates all charts and pivots also.

Is there a way to run the macro when you press REFRESH ALL so that when data changes the pivots and charts are automatically updated without having to activate the macro itself? Thanks.

  • excel
  • vba
  • page-refresh
Share Improve this question edited Mar 15 at 17:04 braX 11.8k5 gold badges22 silver badges37 bronze badges asked Mar 13 at 14:52 MICHAELG1117MICHAELG1117 111 silver badge3 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

Power Query cannot directly call VBA, and it looks like the Refresh All doesn't generate an event. You can however, simulate the event hook ('trigger macro on Refresh All'): just execute VBA when a specific cell changes, and then ensure that RefreshAll always triggers PQ to change that specific cell.

You really only need the MS tutorial. Set up PQ to modify the cell you watch:
https://learn.microsoft/en-us/office/troubleshoot/excel/run-macro-cells-change)

As a test, I placed NOW() in a table, loaded that table into PQ, and then loaded the PQ output into A2. I modify the MS tutorial code to watch A3 for changes. Running Refresh All makes PQ update A3, and that triggers the VBA (image below shows popup after pressing Refresh All).

本文标签：

版权声明：本文标题：vba - There A Way to REFRESH ALL Pivots, Charts, and Data Queries all at once in EXCEL when Pushing REFRESH ALL - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.betaflare.com/web/1744694991a2620222.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。