I have an access database (2007) containing data which I have summarised via
Pivot Tables in an Excel spreadsheet (2007) using Microsoft query (and pivot
the data in excel). The access database contains realtime information, and
hence the pivot tables are refreshed daily to review performance.

I need to move the file location of the database, but when I do this, the
pivot tables are no longer valid, and I can't update them.

I would like to know if there is a way you can move the database and then
update all links in the excel workbook without having to re-build all the
queries individually and link them to the new location of the moved access
database.

Is there a way to update links, similar to how you would in Excel (DataEdit
Links)

Any advice would be very much appreciated