Forum Discussion
Change pivot table cache
Hi Everyone, A couple of years ago I found in a different forum, that you can change the cache ID from a pivot table, you just need 2 functions to do so and I need your help to find what these ar...
If you are using multiple sheets or pivot tables, fully qualify your ActiveSheet reference or even the workbook name to avoid any ambiguities.