Hi
I have an Access database with a few tables in it.
I also have a very basic Excel file which has data imported from the Access file into a pivot table.
When I first set up the pivot table in excel the connection to Access pulls the data through fine. If I edit data in Access and refresh data in Excel the pivot table updates with no problems.
The problem starts when I close the Excel file and re-open it. Refreshing data fails with no error message and I'm unable to pull through updated data. I have to create a new file, a new Access connection and new pivot table to make it work again, but as soon as I re-open the file it fails again.
Does anyone have any idea why this is happening.
Thanks
Bookmarks