I'm writing VBA in MS Access, to run a module which will create the pivot (in Excel) using a local (linked) Access table.
I can easily create the data in Excel and then pivot it, but I don't want to store all the data in another sheet because of high volumes. Ideally I just want the pivot to...