Pivot Table in Excel

[sajith]

hi,

I have a problem using the pivot Table in excel 2000.
Earlier the location of the pivot table in excel was
pointing to say c:\sales.mdb. Now the location has changed
to D:\Sales.mdb. someone please tell me the place to
change in the excel to reflect the same. So that upon
refreshing the document i can see the latest data.
Currently i am getting a error message when i try to
refresh, but its not prompting to change to alternative
location. If i edit the excel file in a notepad...i can
see the location pointing to c:\sales.mdb.

Thanks in advance for any help regarding this..expecting
your replies....

Regards
Sajith

 

[Andy B]

sajith

Select a cell in the pivot table and go to Data>Pivot Table. This will bring
up a Wizard dialog box, and clicking Back will take you to the location of
the data. Change the details here.

Andy.