Notifications
Clear all
Power Pivot
3
Posts
2
Users
0
Reactions
898
Views
Topic starter
I got below error message when I do refresh all. How can I know which pivot table is having the problem? I have a lot of pivot tables in this file... Can I see a list of all pivot tables without using VBA? Thanks!
Posted : 09/03/2023 1:00 pm
Hi Yuan,
There's no built in way to do this, but this VBA code will list all PivotTables and their fields, so you can see which field name isn't meeting requirements.
Mynda
Posted : 09/03/2023 7:09 pm
Topic starter
Thanks Mynda for your help! Indeed I saw people using VBA codes to get the overview but I was hoping there would be a build in way to do this. 🙂
Posted : 10/03/2023 4:50 am