Displaying Last Refresh Date for a Pivot Table in Excel
1. Click on any cell within the pivot table.
2. Go to the
PivotTable Analyze or
Options tab in the ribbon.
3. Click on
Options in the
Data group.
4. In the
PivotTable Options dialog box, go to the
Data tab.
5. Check the box next to
Refresh data when opening the file if it is not already checked.
6. Click on the
OK button to close the dialog box.
7. Go to the cell where you want to display the last refresh date.
8. Type in the following formula:
Formula:
=GETPIVOTDATA("","'PivotTable Name'!$A$1","Last Refresh")
- Note: Replace "PivotTable Name" with the actual name of your pivot table.
9. Press
Enter to display the last refresh date.
This formula uses the
GETPIVOTDATA function to retrieve the last refresh date from the pivot table. The "Last Refresh" argument is a special field name that Excel recognizes and returns the date and time of the last refresh.