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!
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
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.