I have a pivot table in the spreadsheet to link from an Access query.
For some reason, we moved the mdb to another directory.

I need to change to link mdb file. I can change the link after I re
link query for data only. I am unable to change the link for pivot
table.

Any information is great appreciated,