Edit Pivot Query in Code

V

vqthomf

Hi all I have a pivottable using a database but the database has been moved I
am trying to change the sql of the pivot but it's greyed out, I am trying to
do it in code I can creat a pivot but not change the source.
TIA
Charles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change report firlds in pivot tables and charts with one selection 0
Changing pivot table ADO recordset 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Using VBA to create charts 1
Change SourceName on Pivot Table 0
Please help! Cannot open pivotTable source file.... 2
Getting correct labels in Excel pivot 2
Apply multiple filters from list 0

Top