Pivot Table Issues

How to Restore a Hidden PivotTable Refresh Prompt in Excel

Jason MillerJason Miller Oct 21, 2026 872 views

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.

How to Restore a Hidden PivotTable Refresh Prompt in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Click on the 'File' tab in the top-left corner of the Excel ribbon and select 'Options' at the bottom of the menu.

2
Navigate to Data Settings

In the Excel Options dialog box, click on 'Data' in the left-hand pane to access data management preferences.

3
Enable the prompt

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.

Enable Data Prompts in Excel Global Options
Version Compatibility: The 'Prompt for file name on refresh' option may not be visible in newer versions of Excel (like Microsoft 365) unless you are actively using specific legacy external data connections.

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. 1. Open your file in WPS: Launch WPS Spreadsheet and open your existing Excel workbook containing the PivotTable.
  2. 2. Select the PivotTable: Click anywhere inside the PivotTable to reveal the PivotTable Tools tab on the top ribbon.
  3. 3. Adjust settings: Click on 'Options' in the toolbar to easily manage your data refresh preferences and display settings.
  4. 4. Refresh your data: Click the 'Refresh' button in the PivotTable Tools tab to update your PivotTable with the latest source data instantly.
Fully compatible with Microsoft Excel (.xlsx) formatsIntuitive PivotTable creation and refresh controlsLightweight application with fast data processingFree to use with comprehensive data analysis tools
microsoft office alternative - wps office

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'.