xls_mycroft
New Member
- Joined
- Jul 13, 2011
- Messages
- 20
Hi,
I have a datasource with some 140,000 rows in Access. In Excel I have a total of 17 pivot tables, all using the same connection, to run multiple analyses on the dataset.
If I update the connection in Excel 2010 (with Access 2010), the update runs once and takes 8 seconds - so far so good. However, in Office 2007, the update process takes a whopping 450 seconds!
It seems like the update is done 17 times - and that every update takes much long (on average 26seconds). 
Did anybody encounter this issue before? Any idea on how to solve/circumvent the issue?
Thanks!
I have a datasource with some 140,000 rows in Access. In Excel I have a total of 17 pivot tables, all using the same connection, to run multiple analyses on the dataset.
If I update the connection in Excel 2010 (with Access 2010), the update runs once and takes 8 seconds - so far so good. However, in Office 2007, the update process takes a whopping 450 seconds!


Did anybody encounter this issue before? Any idea on how to solve/circumvent the issue?
Thanks!