External Data
 

Frank & Jamie,

When importing data using an existing query, (via Data/Import External
Data/Import Data), the "Select Data Source" dialog box pops up, from which I
select an existing query. Then another box titled "Import Data" pops up,
giving one the options of editing the query and also selecting "Create
PivotTable report...". The trouble is, once the PivotTable has been created
by this direct method, Excel does not recognize anywhere in the PivotTable as
being inside the Query range - therefore the Edit Query button on the
External Data toolbar remains grayed out. The only way I can edit this is go
back to the original query and re-construct the PivotTable again.

If anyone has any suggestions, that would be great!
Andrew

"Jamie Collins" wrote:

"Frank Stone" wrote ...

The data source is in Microsoft query. click somewhere
inside your query range then click
toolsget external dataedit query.
If the wizard comes up, go the the last page(4) and choose
view data or edit query in microsoft query.
once in microsoft query go to ViewSQL.
edit the file path protion of the database query to the
new database name

Frank,
You standard answer to this type of question ignores the fact that the
database path does not always appear in the SQL query text. The
connection string should be changed. See:

http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn

Jamie.

--