Excel Online Pivot Table Drill Down

Excel Online Pivot Table Drill Down



 Mar 07 2022

Our Enterprise is moving from Desktop Excel to Online Excel - collaborative features and sharing in MS Teams and Sharepoint (OneDrive) present a massive improvement in productivity and future RPA possibilities - with one exception:-


Pivot table drill down (double click on value in pivot).  In the latest Excel O365 Desktop version it opens a new sheet with Table summary of underlying data as expected. In online version it edits the cell.


If you attempt the exact same workflow in Google Sheets pivot table drill down works perfectly. Google have this implemented already. 


Using excel to analyse data in Pivot tables plays a big part of Enterprise workflows - having to download and re-upload defeats the purpose of online cloud simultaneous collaboration - this is a key feature of pivot tables and request a backlog discussion for this request.