Retrieves the current values from the data source for all edited cells in a PivotTable report that is in writeback mode. This method applies only to PivotTable reports with OLAP data sources. Trying ...

Returns the date on which the PivotTable report was last refreshed. Read-only Date. This example displays the date on which the PivotTable report was last refreshed.

While the PIVOTBY function can only reference source data in Excel, if you create a PivotTable in Excel 2016 or later or Excel for Microsoft 365, you can choose to pull in data from an external source ...