Pivot Table Looping
Posted by Cindy McCracken on December 03, 1999 1:47 PM
I am writing an Access function to refresh Excel pivot tables. My problem is that the function will not know how many pivot tables there are on a worksheet. So, I need it to somehow loop thru and refresh any it finds. Does anyone have a good way to do this? I tried using a pivot table collection, but the Refresh method won't work. I can use a table array but the function crashes after doing the last table, with message of Unable to get the Pivot Table property of the worksheet class.
Any ideas or suggestions would be welcomed.