Have a large file (157mb) with 50+ pivot tables and each pivot table is tied to powerpivot models (4 main data loads).... Each time I adjust a filter... I get "reading data..." for 30+ seconds... Having to adjust 50+ pivot tables in this manner is a gigantic waste of time and i'm left wondering if there isn't anything I can do to improve the refresh speeds of powerpivot.
-
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.
any tips for improving refresh speeds?
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
What type(s) of data sources are being imported into the model with your 4 main data loads?
Upvote
0
Similar threads
- Question
- Solved
