Pivot Table - Change SQL Statement Problem
I've been trying to change the database of a pivot table connection. I've
used some code found in KB article 269619. The code works ok unless the table is derived from another pivot which is the case for the majority of my pivot tables. Has any one figured out a work around? Also, is there a way to determine which pivot table is the original and which is based on previous tables? Thanks - John Michl |
All times are GMT +1. The time now is 03:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com