Hi


I've connected my excel sheet to 4 separate queries in the same Access database. I did this one at a time via the 'Get Data from Access' button. The data is just inserted as tables in separate tabs in the excel file. I then have a couple of pivot tables based on 2 of the tables.


When I refresh the data to reflect changes made in Access, I find I can only refresh one table at at time (right click refresh on one of the list items) - if I try to refresh one of the other tables afterwards I can an error:


The query did not run, or the database table could not be opened


If I close and save the file, I can then go in again and refresh a different table and it works, but I can still only do one before I have to close and restart.


Is this an issue with how I've attached the data? - or some sort of security setting?


Thanks for reading!