Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
if statement on a pivot table | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
"IF" statement in a pivot table. | Excel Discussion (Misc queries) |