pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 461
- Office Version
- 2016
- Platform
- Windows
Rather than do them one at a time, I'd love to have some VBA that would run through all tabs of a workbook and, for each pivot table, change the data option to "None" instead of "Automatic" so that unused items are not retained in the cache, and then refresh the pivot table.
Is this possible in a single piece of code?
Is this possible in a single piece of code?