Sep 22 2020 03:45 AM
Hello, I wanted to double click on pivot table created through data connections in excel 2013 and get more than 1000 rows. OLAP drill through in properties is greyed out. Please assist
Sep 22 2020 06:02 AM
In general it shall work if you have aggregations within PivotTable. Perhaps bug in 2013 which is mentioned here https://social.technet.microsoft.com/Forums/office/en-US/b6b00062-cefa-4657-beeb-575d4a6dd6c3/maximu... , but IMHO, it shall be fixed.