I posted this in the general forum and got no response
I'm hoping someone can help.

I have an excel file with a bunch of pivot tables that
are linked to an access db. I moved the two files from
my desktop into a folder and now the pivot tables won't
update because the link from the pivot to the db is
wrong. I can't find a way to reestablish the link
without recreating all the tables. Any ideas? (moving
them back to my desktop doesn't count).

Thanks for any help.

Ian.