Hi.
I've created pivottables based on data in Access, using the pivot wizard.

I want to change the location of the Access database(db).
I've already changed the db-location in the SQLcode in the query that gets
the data to the pivot.
Unfortunately when opening the xls-file, and refeshing the data, Excel still
seeks for the 'original' database, which it cannot find anymore, since I
moved it.

Why doesn't it work when I've changed the location in the sql?
Does Excel store the original location somewhere, and where is that?

But the main question:
What do I have to do to make this work, without having to built-up the
Excelfile from scratch?

Rishi