There were some issues with exports to Excel in the initial release of Access 2010. Most of those were resolved with SP1 when it was released in mid-2011, so you might want to check and make sure you have the service pack installed. Also, it's not clear where the PIVOT is being done. Is it in the SQL Server view, or is Access performing the pivot? Finally, how is the connection to SQL Server being made - using ODBC data sources or with direct connection strings? Or is this the ADP format?

Wendell