I have an Excel Spreadsheet with a data model with several tables in it that are linked together in the data model. Then I have created a Pivot Table in Excel based on the measures and tables in the data model. My simple question is, if I go to the Data Ribbon and hit Refresh All, is it supposed to always refresh the queries AND the Pivot Table as well? I can't completely tell what is going on. Thanks for the help.
-
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.
Refresh
- Thread starter MikeDBMan
- Start date
-
- Tags
- refresh all
schwiggiddy
New Member
- Joined
- Sep 5, 2017
- Messages
- 31
If the Pivot Table is based on the content of the data model, it should refresh at the same time as the source queries. If the Pivot Table is based on the cells loaded into the worksheet, you'd need to refresh the PT separately after the queries refresh.
Upvote
0
Everything is in the data model but a couple small reference tables reside within this same spreadsheet. Since things appear to me to not refresh unless I also refresh the pivot tables, do you think that might be the reason? I could move those tables and see but thought I'd ask for your thoughts first. Thanks.
Upvote
0
schwiggiddy
New Member
- Joined
- Sep 5, 2017
- Messages
- 31
In my experience, if the pivot table fields list is based on a source that includes this icon, it'll refresh with the query.
If it doesn't have the orange component, it will require a separate refresh. When you make the PT, be sure to click the radio button to use the workbook's data model as the source.
Upvote
0
