I'm in Excel 2010 connecting to multiple Access 2010 db's from Excel through PivotTable data connections.
Refreshing all my connections causes the final refresh to fail. The order does not matter, I've manually refreshed in different orders, same error.
However, if I save and close after refreshing a few, then come back and refresh the last one, there is no problem at all.
Leads me to believe that I'm hitting some sort of memory cap that is reset when I save and close.
Can I re-create that effect through VBA without actually save/closing? Is there a better solution to this issue?
Error Messages - These three pop up in this order:
Refreshing all my connections causes the final refresh to fail. The order does not matter, I've manually refreshed in different orders, same error.
However, if I save and close after refreshing a few, then come back and refresh the last one, there is no problem at all.
Leads me to believe that I'm hitting some sort of memory cap that is reset when I save and close.
Can I re-create that effect through VBA without actually save/closing? Is there a better solution to this issue?
Error Messages - These three pop up in this order:
- The query did not run, or the database table could not be opened.
- Problems obtaining data.
- A PivotTable, cube function or slicer using connection has failed to refresh.