Progam Pivot Table connection via OLE DB (vs ODBC)

  • Thread starter Thread starter Grd
  • Start date Start date
G

Grd

Hi,

Is this possible to do through Pivot Table Wizard?
Is there VBA code to help me here?

Any help would be appreciated.

Tx

Suzanne
 
Hi,

In the first step of the Pivot Table Wizard choose External Data Source,
Next and follow the step of the wizard. You can record the whole process to
help you get started with the VBA stuff.
 
tx v much - I'll try that

ShaneDevenshire said:
Hi,

In the first step of the Pivot Table Wizard choose External Data Source,
Next and follow the step of the wizard. You can record the whole process to
help you get started with the VBA stuff.
Click to expand...
 
You must log in or register to reply here.

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

How to modify the sql statement on a pivot table using VBA- XL2000 1
Pivot table multiple filters 2
How to build / refresh pivot table without ODBC?? 1
Pivot Table Grouping from OLE DB source 2
create a pivot table and chart from a named range 1
Playing back a Pivot Table macros 2
refresh multiple pivot tables in workbook 2
Using VBA on Excel Pivot Tables 3

Back
Top