Pivot Table - refreshed from ODBC connection

[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!

 

[Ben W]

Might I add, the "Edit Query" option on the menu is disabled!