When going to Data > Refresh All I suspect that it is refreshing pivot tables then refreshing the source (power query queries) of the pivots. Is there a way to specify the refresh order. The workbook in question isn't so large that I can't go from tab to tab refreshing the queries then the pivots. But, if there is a viable way to order the refresh I can think of other workbooks that might benefit. I'm fairly comfortable with VBA but PQ is still a new thing to me and I wasn't sure if there were settings I could manipulate. Thanks for looking.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data > Refresh All order
- Thread starter Mr_Phil
- Start date
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,320
- Office Version
- 365
- Platform
- Windows
Check this link and see if it works for you
Is there a way to control Refresh All data order
I have a database query and a table based off that. When I run Refresh All Data, I think they both run at the same time instead of one after another which..
techcommunity.microsoft.com
Upvote
0
I'll give it a shot. Thanks.Check this link and see if it works for you
Is there a way to control Refresh All data order
I have a database query and a table based off that. When I run Refresh All Data, I think they both run at the same time instead of one after another which..techcommunity.microsoft.com
Upvote
0
