[AccessD] Import CrossTab query to Excel 2007

Mark Simms marksimms at verizon.net
Sat Jul 27 09:16:12 CDT 2013


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.





More information about the AccessD mailing list