https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668381#M200340 This is a pivot table in Excel which uses the SAS MS add-in to reference datasets from our SAS grid.&nbsp; Fri, 10 Jul 2020 14:28:56 GMT Mike7058 2020-07-10T14:28:56Z https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668192#M200248 <P>I’ve used indexes in the past for querying data but never attempted them for pivoting.&nbsp; Would anyone know if indexes or any other methods of speeding up these pivots?</P> Thu, 09 Jul 2020 21:20:08 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668192#M200248 Mike7058 2020-07-09T21:20:08Z https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668203#M200259 What are you defining as a pivot and how does Excel come into play here?<BR /><BR />Are you referring to tabulate/report options or are you using the Excel Add In or something else? We need more details. Thu, 09 Jul 2020 22:15:57 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668203#M200259 Reeza 2020-07-09T22:15:57Z https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668381#M200340 This is a pivot table in Excel which uses the SAS MS add-in to reference datasets from our SAS grid.&nbsp; Fri, 10 Jul 2020 14:28:56 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-ways-to-speed-up-Excel-pivots-against-large-datasets/m-p/668381#M200340 Mike7058 2020-07-10T14:28:56Z