Pivot Table - refreshed from ODBC connection

  • Thread starter Thread starter Ben W
  • Start date Start date
B

Ben W

Is it possible to change the query of an already made Pivot Table which
refreshes via ODBC connection?

The Excel is refreshed using a query, with connection information (sample
below). I want to change some of this info, but can't seem to do it without
having to re-create the Pivot tabel from scratch!?

XLODBC
1
DSN=Sample C/ODBC 32 bit;CSF=Yes;SName=myserver;NType=tcp;PPath=C:\Program
Files\Navision Financials;UID=super;CN=MyCompany;SERVER=N;
SELECT "abc" etc...



Please help!
 
Back
Top