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
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.