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?
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.
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.