How to change SQL in an existing pivottable

M

Michael

Hi,

I need some sample code to change SQL in an existing pivottable named
as Table1. Thanks a lot. Mike.
 
J

Joel

Can you record a macro while creating the pivot table so we can see what you
are trying to change. I'm not sure where the source of the pivot table is
coming from and the macro will make it easier to write the code.
 

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

MS Query Application Window Remains Open After Refreshing PivotTable 1
SQL Codeing behind a PivotTable 14
set pivottable source data to range name 1
Creating an older version pivottable 1
Please help! Cannot open pivotTable source file.... 2
Pivot Table 1
Pivot Chart - Disassocoation from PivotTable 1
Changing PivotTable source 3

Top