[AccessD] Import CrossTab query to Excel 2007

Hi Mark,
Thanks for the guidance.



Nicholas



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Saturday, 27 July, 2013 22:16
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Import CrossTab query to Excel 2007

AN alternative is to insert a query table and connection to the Access query
with the cross tab and then do the cross tab in Excel via PivotTable.
However, there is a huge caveat: Pivot Tables with a direct connection to an
Access table or query do not refresh properly when page-level filters are
employed. The pivotcache becomes corrupted and the results are incorrect.
One workaround is do put the data on a sheet via query table and then source
the pivot table from that sheet.



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com