Hi,
yes it is.
click somewhere inside the queryrange.
click the edit query icon.
on the last sheet of the query wizard click
view data or edit query in microsoft query then click
finish
when microsoft query comes up click ViewSQL
here delete out the old file path and enter the new file
path.
The data source has been changed.
:)
-----Original Message-----
Hi,
I use an extern excel-database. This database changes
every week, but the
lay-out stays the same. So only the figures change. I
have made al lot of
query's in excel who are connected to the extern
database. The query's work
very wel but now I want to change the source of my extern
database. My
question, Is it possible to change the source of an
extern database without
changing the whole query.

Greetings Mark from the Netherlands
.