Forum

Notifications
Clear all

pivot table error

3 Posts
2 Users
0 Reactions
172 Views
(@yuanzhang0308gmail-com)
Posts: 31
Trusted Member
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!error-pivot-table.PNG

 
Posted : 09/03/2023 1:00 pm
(@mynda)
Posts: 4762
Member Admin
 

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
(@yuanzhang0308gmail-com)
Posts: 31
Trusted Member
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
Share: