Can a PivotTable Detail Sheet Refresh Automatically?
Question details
The user wants to know if a detail sheet generated by double-clicking a PivotTable value can automatically update when the original source data changes.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Attempting to keep drill-down detail sheets synchronized with live source data or an updated PivotTable.
- Observed behavior
- The generated detail worksheet acts as a static, one-time snapshot of the underlying records and does not automatically refresh alongside the PivotTable.
Before proceeding, ensure you have saved any recent changes to your main data source and refreshed your primary PivotTable, as you will need to regenerate the detail sheet to view the most current records.
Regenerate the PivotTable Detail Sheet
Because the detail sheet is designed as a static snapshot, the standard solution is to delete the outdated sheet and extract a new set of records.
When you double-click a value cell in a PivotTable, the application immediately extracts the underlying records at that exact moment and places them in a new worksheet. This extracted data is not dynamically linked to the original source. To view updated details, you must manually perform the drill-through action again.
Locate the sheet tab containing the old drill-down data at the bottom of your screen. Right-click the tab and select 'Delete' to remove it.
Return to the worksheet that contains your main PivotTable. Right-click anywhere inside the PivotTable and select 'Refresh' to ensure it reflects the latest changes from your source data.
Double-click the specific value cell in the PivotTable that you wish to analyze. A new worksheet will automatically be created containing the fully updated, current underlying records.

Easily Manage PivotTables and Data Analysis with WPS Spreadsheet
WPS Spreadsheet offers powerful data analysis tools, including fully featured PivotTables that are perfectly compatible with Microsoft Excel formats. You can effortlessly summarize, drill down, and analyze large datasets for free.
- 1. Open your data file: Launch WPS Spreadsheet and open your dataset or existing PivotTable file.
- 2. Insert a PivotTable: Navigate to the 'Insert' tab and click 'PivotTable' to create your data summary.
- 3. Refresh your data: After modifying your source data, right-click the PivotTable and select 'Refresh' to update the summary.
- 4. Extract detail records: Double-click any summarized value cell to instantly extract its detailed underlying records into a fresh, static worksheet.

Frequently Asked Questions
Why did my PivotTable detail sheet stop updating?
The detail sheet created by double-clicking a PivotTable value is intentionally designed as a static, one-time snapshot. It does not contain formulas or active links to the source data, which is why it stops matching the source once updates occur.
Can I link the drill-down detail sheet to the source data?
By default, the standard PivotTable drill-down feature cannot create a live link. If you need a dynamically updating subset of data on a separate sheet, consider using the FILTER function or Advanced Filter features instead of a PivotTable drill-down.
How do I update the detail records after changing my source data?
You must first right-click and refresh the main PivotTable. Once the PivotTable reflects the new data, delete the old detail worksheet, and double-click the summarized value again to generate a new snapshot worksheet.




