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

Hi

Try downloading Ron Coderre's Addin - Pivot Play Plus.
This will allow you to edit the links in Excel very easily
http://www.contextures.com/PivotPlayPLUS.zip

--
Regards
Roger Govier

"Rishi" <(E-Mail Removed)> wrote in message
news:CC4809D7-A8C9-4C19-87D1-(E-Mail Removed)...
> 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
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4244 (20090715) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4244 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Hi Roger,

thanks for your reply.
This add-in did the job.

I'm just wondering:
How would this be done without this add-in?

Rishi

"Roger Govier" wrote:

> Hi
>
> Try downloading Ron Coderre's Addin - Pivot Play Plus.
> This will allow you to edit the links in Excel very easily
> http://www.contextures.com/PivotPlayPLUS.zip
>
> --
> Regards
> Roger Govier
>
> "Rishi" <(E-Mail Removed)> wrote in message
> news:CC4809D7-A8C9-4C19-87D1-(E-Mail Removed)...
> > 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
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 4244 (20090715) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
> __________ Information from ESET Smart Security, version of virus signature database 4244 (20090715) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>