Pivot retreiving data

Occasional Visitor

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

1 Reply


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.