I'm using the same pivot cache for 6 pivot tables for 6 worksheets in a workbook. I'm wondering how I can use just one pivot cache. I'm trying to follow this post in contextures, but I don't think it uses SQL Connections and I am wondering what I am missing.
This is the code I get when I connect to make the pivot table from the SQL Server.
The question is, how do I write the source data above into the code below.
Thanks for the help. At minimum, writing this out will help clarify the problem for me.