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 do***ent 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

pramod anchuparayil

If you are using ODBC to connect to the access database change it using the
ODBC control panel.

Pramod

lutz morrien

Easiest way is probably just deleting the old pivot table
and creating a new one. If you use an olap cube as
source, there will be a prompt for invalid connection,
though.

HTH Lutz