I have an Excel pivot table whose source information is an Access table. I want to change the database which is the source.

When I right click on the pivot table, I can't change the name of the database source. When I am on top of the pivot table and click on Data/Import External Data, I can't select anything (none of the options are available). I don't know if one of these methods should work or if I should be using some other function. This is new to me!

This is a small matter. I could just delete the pivot table and recreate it when my Access data source changes, but I figured this might be a quick fix.

Hello,

see if this earlier discussion helps.

Martin