How to Restore a Hidden PivotTable Refresh Prompt in Excel
Question details
The user wants to restore the confirmation prompt that appears when refreshing a PivotTable after previously selecting the 'Do not show this again' option.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Updating PivotTable data connected to an external source or internal range where a prompt used to appear.
- Observed behavior
- The refresh prompt no longer appears when updating PivotTable data because it was dismissed permanently by the user.
Ensure your Excel workbook is saved and verify whether your PivotTable is connected to an external data source, as the prompt settings heavily depend on the data connection type.
Enable Data Prompts in Excel Global Options
This is the most direct method to restore file name prompts for external data refreshes in Microsoft Excel.
When you check 'Do not show this again' on certain external data prompts, Excel saves this preference in its global application options. You can reverse this by adjusting the Data settings.
Click on the 'File' tab in the top-left corner of the Excel ribbon and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, click on 'Data' in the left-hand pane to access data management preferences.
Look for the external data settings and check the box for 'Prompt for file name on refresh' (if available in your version). Click 'OK' to save your changes.

Check PivotTable Data Options
Modify the specific settings of the PivotTable to ensure background refreshes and data handling are configured correctly.
Manage PivotTables Easily with WPS Spreadsheet
WPS Spreadsheet offers a highly compatible and intuitive interface for creating, managing, and refreshing PivotTables without the hassle of hidden legacy settings.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your existing Excel workbook containing the PivotTable.
- 2. Select the PivotTable: Click anywhere inside the PivotTable to reveal the PivotTable Tools tab on the top ribbon.
- 3. Adjust settings: Click on 'Options' in the toolbar to easily manage your data refresh preferences and display settings.
- 4. Refresh your data: Click the 'Refresh' button in the PivotTable Tools tab to update your PivotTable with the latest source data instantly.

Frequently Asked Questions
Why is the 'Prompt for file name on refresh' option missing in my Excel?
This option might be unavailable in newer versions of Excel or if your PivotTable isn't connected to an external OLE DB/ODBC data source that requires a specific file path to refresh.
Does resetting all Excel settings bring back the prompt?
Resetting all Excel settings or reinstalling the software is usually unnecessary and might not restore specific data connection prompts. It is better to check the PivotTable Options and File Data connection properties first.
How do I refresh my PivotTable automatically when opening the file?
Right-click the PivotTable, select 'PivotTable Options', navigate to the 'Data' tab, and check the box that says 'Refresh data when opening the file'.




