Pivot to an Access Database

M

Michael Rekas

Hi there

I have created a PivotTable which succesfully reads in data from an
Access database.

The problem I have is that if the path to the Access database is
stored somewhere in the PivotTable so that if the database location
changes the PivotTable cannot refresh as the database is not found.

Is there any way to fix this - short of recreating the PivotTable?

Thanks in anticipation.

Michael
 
Top