Changed Location for Pivot Source

[Majiste]

I have a pivot table linked to an Access table. The Access database has been moved to a different location on the network and now I can't update the Pivot table. Is there a way to let the pivottable know where the Access DB has been moved to?

Thanks

 

[Telsa]

Try putting the cursor in pivottable and then click on pivottable icon. Then select the BACK button and you should be able to change it there. I know that is where I change the range so I'm assuming you can change the link there as well.

 

[Majiste]

I've tried that. The weird thing is you can change the source as long as it's in the original database. There's no place to change the location of the database itself!