Excel’s January 2023 Update introduced a handful of new features to Microsoft’s spreadsheet product. The main highlight of the update is the PivotTable “Show Details” feature for Excel for the web. Other additions include the Power Automate tab for Excel for Windows and Mac and some new features for Insiders to test.
Excel for the web’s new feature is the result of users’ feedback, according to Microsoft. The new PivotTable “Show Details” option allows users to view the source data for a PivotTable value cell. It is a handy function that helps users understand how the values in a PivotTable are calculated.
“For example, if you see an unexpected value in your PivotTable, you can use Show Details to confirm whether the source data used to calculate that value is as expected or if there is an issue with the underlying data,” Microsoft explains.
PivotTable “Show Details” option is accessible through a double-click or a right-click, but there’s also a dedicated button for it from the PivotTable tab of the ribbon.
Meanwhile, Excel for Windows and Mac will both get the same access to the Power Automate tab starting today. The new tab offers options for creating and modifying scripts that allow the automation of repetitive tasks using Office Scripts. Users can connect different Microsoft apps like Microsoft Teams or SharePoint to build workflows, schedule Office Script, and more.