C# code to export the pivot grid. make sure you set the auto post back to false
protected void cmdExportToExcel_Click(object sender, EventArgs e) { pvGridExport.ExportXlsxToResponse("OPW Sales Monthly Distributor"); }