Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
When an Excel PivotTable is not updating, select any cell in it and choose Refresh; use Refresh All when every PivotTable in the workbook must reflect new data. If newly added records still do not appear, the refresh is working but the PivotTable’s source range stops before those records. Open Analyze > Change Data Source and select the complete range or an Excel Table that contains the new rows. External connections, unsaved query files, renamed columns, automatic-refresh limits and blocked output can cause different symptoms, so the fix depends on where the data comes from.
What should you do first when an Excel PivotTable is not updating?
Start with a manual refresh. Click inside the PivotTable, then choose Refresh on the PivotTable tab or on the right-click menu. Microsoft also documents Alt+F5 for refreshing the selected PivotTable. To refresh every PivotTable and other refreshable connections in the workbook, choose Refresh All. The commands and tab names vary slightly between Windows, Mac, Excel for the web and iPad, but the principle is the same: the PivotTable must be told to read its source again.
As an Amazon Associate I earn from qualifying purchases.
Use Refresh Status if the operation appears slow. A long refresh does not necessarily mean that the PivotTable is frozen; an external database, Power Query step or large source can take time. Wait for the status to finish before deciding that the data is still stale. Microsoft’s PivotTable refresh guidance covers the commands and platform-specific controls.
Why does Refresh not bring in rows I just appended?
A refresh recalculates the PivotTable from the source definition; it does not automatically enlarge a fixed cell range. If the PivotTable was created from A1:H500 and you added records on row 501 or below, those rows are outside the source and cannot appear until you change that definition.
Popular on Amazon
- 【90 Degree Full Function USB C Adapter】Supports the latest USB4 standard for up to 40Gbps of bandwidth, 8K video support, and up to 240W Fast charging; Support USB PD 3.1 Extended Power Range (EPR) including 140W, 180W and 240W. Your productivity is easily doubled. *Warm Tip: For the best fit, please make sure the USB-C port is fully exposed; thick or bulky cases may affect compatibility.
- 【Reliable Quality】Made from high-quality, scratch-resistant aluminum alloy, delicate metal frame. get excellent wear resistance and heat dissipation. Non-Slip Design for easier insertion and removal.
- 【Small and portable】Ultra thin size, ultra compact design, a petite physique that matches the minimalist design of your modern laptops. Coming with a slim figure that won't block the port next to the one it's plugged into.
- 【Compatibility】Widely work with most usb c, thunderbolt 4/3 devices. Compatibilit for ROG Ally, Steam Deck, Switch, MacBook Pro, Quest 3 VR headset, Surface Book 2, iPhone 18/17/16/15, Samsung Galaxy S23/S22/S21, Note 20/10, Google Pixel, ChromeBook, etc.
- 【Excellence Customer Support】If you experience any issues or cable failure, simply reach out to our dedicated customer service team. We provide a prompt response within 18 hours, providing you with the necessary technical support to resolve any concerns.
- Click a cell in the PivotTable.
- Open the Analyze tab (called PivotTable Analyze in some Windows builds) and choose Change Data Source.
- In the dialog, inspect the current table or range. Highlight the full range, including the header row and all newly appended records, or select the correct Excel Table from the list.
- Confirm the change, then run Refresh again.
The supported workflow is described in Microsoft’s article on changing a PivotTable’s source data. If the source has been substantially restructured—columns removed, renamed or rearranged—creating a new PivotTable can be safer than trying to repair a definition built around the old layout.
How can an Excel Table prevent the source range from going stale?
For a growing local dataset, convert the source into an Excel Table and use that Table as the PivotTable’s source. When rows are added inside the Table, a refresh includes those changes instead of relying on a manually typed end-row address. Microsoft specifically notes that refreshing from an Excel Table automatically includes changes made to that table’s external data source.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteTo use this approach, select the source data, choose Insert > Table (or Ctrl+T on Windows), confirm that the table has headers, and give it a clear name in Table Design. Then select the PivotTable, choose Analyze > Change Data Source, and select that Table. New records must actually be entered in the Table’s rows—typing data underneath an unrelated range does not make it part of the Table. After adding records, refresh the PivotTable.
Tables are most useful for data stored in the workbook. They do not remove the need to maintain a valid connection when the PivotTable reads from a database, a Power Query result or another external source.
What is the difference between Refresh and Refresh All?
Refresh updates the PivotTable containing the active cell. Refresh All updates all PivotTables and refreshable workbook connections, which is useful when several reports depend on the same data or when a dashboard contains multiple PivotTables.
Also popular on Amazon
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Use Refresh when you are diagnosing one report and want a quick, contained operation. Use Refresh All after changing a shared query or external connection, but allow more time because unrelated connections may also run. If one connection fails, inspect the error details rather than assuming that every PivotTable received new data.
How do you tell whether the problem is the data, the range or the display?
Compare the symptom with the likely cause before changing settings:
| What you see | Most likely cause | Next action |
|---|---|---|
| Edited values remain old | The PivotTable has not been refreshed | Select it and choose Refresh; use Refresh All for the workbook. |
| Newly appended rows are absent | The source range ends before the new rows | Use Analyze > Change Data Source to select the complete range or an Excel Table. |
| Refresh reports an external or query error | Connection, permission, saved-file or schema problem | Verify availability and access, check renamed or deleted tables and columns, and save open source files. |
| Data changes appear only after opening or manually refreshing | Refresh timing or feature availability | Review refresh-on-open and Auto Refresh settings, including their source and version limitations. |
Refresh results in #SPILL! |
Cells block the PivotTable’s expanded output | Clear or move the blocking cells, or move the PivotTable to an area with room. |
This separation matters: changing the range cannot repair a database login failure, and enabling automatic refresh cannot include rows that are outside a fixed source range.
How do you set a PivotTable to refresh when the workbook opens?
Open the PivotTable’s options and look for Refresh data when opening the file. In desktop Excel, right-click the PivotTable, choose PivotTable Options, open the Data tab and enable the refresh-on-open setting when it is available. Microsoft documents this option in its PivotTable options reference.
The option is not universal. Microsoft says refresh-on-open is unavailable for OLAP data sources, and the exact controls depend on the Excel edition and the type of connection. A workbook that works this way on a local table may behave differently when its PivotTable is connected to an OLAP cube or another server source.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Also popular on Amazon
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Microsoft also describes an Auto Refresh feature for PivotTables connected to local workbook data. At the time covered by the documentation, that feature was available to Microsoft 365 Insider participants, not guaranteed for every production installation. Its setting is per data source, so changing it can affect multiple PivotTables that use that source. Do not promise users that a regular Excel 2016, 2019, 2021, 2024 or Microsoft 365 installation will have the same automatic-refresh controls; check the build and rollout status first.
What should you check when the PivotTable uses external data?
If a manual refresh returns an error instead of new values, treat it as a connection or schema problem. Confirm that the database, server or file is reachable and that your account still has permission. A password change, expired credential, VPN requirement or unavailable network can prevent a refresh even when the PivotTable layout itself is correct.
Next, verify the source schema. A table or column that was renamed or deleted can break a query or connection; restore the expected name or edit the query to use the new one. Microsoft’s guidance on refreshing external data connections covers connection availability and access checks.
For Power Query sources, save the source workbook or file before refreshing. Microsoft notes that edits in an open source file may not be included until that file is saved. Close or save the source, then refresh the query and the PivotTable again. If the error identifies a missing column, changed data type or renamed table, fix that source or query step before repeatedly pressing Refresh; repetition cannot correct a broken schema.
Free tools Windows power users keep installed
One-click scans. No signup required.
How do you fix a PivotTable that shows #SPILL! after refresh?
A #SPILL! result means the refreshed PivotTable needs to expand into cells that are not available. Inspect the area immediately around the PivotTable for typed values, formulas, merged cells or other content. Move or clear the obstructing cells, then refresh again.
Also popular on Amazon
- Portable and powerful USB-C HUB: BENFEI USB Type-C HUB, with super-soft and knot-free silicone woven design cable, meets most mobile office needs. Compact, lightweight, stylish, and powerful portable USB C Hub equipped with 1 x HDMI port, 1 x 100W charging, and 3 x USB ports. 18-month warranty, 24-hour response, to ensure you feel at ease when using our product.
- Design centered on comfort and reliability: Thanks to BENFEI's end-to-end in-house cable production capability, in-house PCBA and assembly capability, using the industry's most advanced silicone woven design and process, 20cm cable in length, no knots, super-soft, the HUB is easy to use in all scenarios: laptop, tablet, stand etc. Super-soft, 25000+ life cycles, to meet your daily carrying and office needs.
- 100W Charging: Support up to 90W USB C pass-through charging via Type-C port to keep your laptop powered. 10W is reserved for other interface operations. No data and video function on the Type-C port.
- 4K HDMI Display: The HDMI port supports media display at resolutions up to 4K 30Hz, keeping every incredible moment detailed and ultra vivid. Please note that the C port of the Host device needs to support video output.
- Transfer Files in Seconds: Transfer files and from your laptop at speeds up to 10 Gbps with USB A 3.2 port. Extra 2 USB A 2.0 ports are perfectly for your keyboards and mouse.
If the surrounding worksheet must remain occupied, move the PivotTable to a blank area or a new worksheet. Microsoft’s instructions for correcting a PivotTable spill error recommend removing the obstruction or relocating the PivotTable so its output has room. This is a display-space issue, not evidence that the source range failed.
What are the exact steps for the common “old values” case?
Use this short sequence when you changed cells that were already inside the source and the report still shows the previous result:
- Click a value or label inside the PivotTable.
- Choose Refresh from the PivotTable tab or the right-click menu. On supported desktop versions, Alt+F5 performs the same selected-PivotTable refresh.
- Wait for the refresh to finish. If it is slow, open Refresh Status rather than interrupting it immediately.
- Check whether the edited source cell is in the range shown under Analyze > Change Data Source.
- If it is outside that range, correct the range or switch the source to an Excel Table, then refresh again.
- If the report is one of several dependent PivotTables, run Refresh All and check each output.
This sequence avoids the most common mistake: repeatedly refreshing a PivotTable whose source definition never included the new rows.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesWhen should you create a new PivotTable instead of repairing the old one?
Repair the existing PivotTable when the source still has the same basic columns and only the range endpoint or refresh timing is wrong. Create a new PivotTable when the source has been substantially restructured—especially when fields were removed, renamed or reorganized—and the old field layout no longer maps cleanly to the data.
Before rebuilding, record any calculated fields, filters, grouping and formatting that the existing report needs. Then select the corrected Table or range as the new source and recreate the required layout. A new PivotTable does not solve an inaccessible external database, so resolve connection and permission errors first if the source is not local.
Also popular on Amazon
- 【Read before You Buy】 Note: This adapter is USB 2.0 version and cannot transmit HDM, VGA, or other video signals. Nevertheless, they are fully capable of charging devices,duplicating files, and can be seamlessly integrated with USB-C earphones, wireless network adapters, and SD card adapters.
- 【Easy to Use and Safe】Thanks to modern manufacturing techniques, we've made these adapters sufficiently compact so that they can remain inserted in your device without noticeable protrusion or inconvenience. This means you don't have to constantly plug and unplug them, reducing the likelihood of wear and misalignment, and making them more convenient to carry around.
- 【Reliable Quality】Engineered for enhanced durability, durable aluminum alloy shell material,get excellent wear resistance and heat dissipation,the male USB C and female USB connectors & the male USB and female USB C connectors are designed to be plugged and unplugged up to 20000 times. Provides data transfer, device charging, memory space expansion, and additional computer peripherals.
- 【Think more for you】Do you need to connect a USB-C-enabled device to an odd device that only has USB-A ports? Then these USB-A male to USB-C female adapters are made for you.Simply insert the adapter into the USB-A port on the device, and you can instantly connect your USB-C device to the device that originally didn't have the correct connection port.
- 【Trusted xiwxi Quality and Service】As a responsible brand seller, you will receive xiwxi's 12-month Quality assurance and lifetime friendly customer service, you're not just buying a product,you're investing in peace of mind with all-round quality and exceptional customer service.
Which Excel versions and platforms support these fixes?
Microsoft’s refresh documentation covers Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 for the listed platforms, but the available controls differ between Windows, Mac, Excel for the web and iPad. The cited source-range workflow applies to Microsoft 365, Excel for Mac, Excel 2024 and Excel 2021 in Microsoft’s stated applicability notes.
If you cannot find Analyze, Change Data Source or a refresh-on-open checkbox, first verify that you selected a PivotTable cell and then check the platform and build. Excel for the web and iPad may expose fewer desktop controls. Avoid giving a Windows menu path as if it were identical on every device.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →How can you prevent the problem from returning?
- Use an Excel Table for expanding local data. Keep new records inside the Table and use that Table as the PivotTable source.
- Keep one header row and stable field names. Renaming or deleting columns can break queries and existing PivotTable layouts.
- Save source files before refresh. This is particularly important for Power Query sources edited in another workbook.
- Document external credentials and dependencies. Note the database, file path, permissions and any VPN or gateway requirement so a connection failure is diagnosable.
- Leave expansion space around reports. A PivotTable needs clear cells to grow after a refresh; place dashboards where output will not be blocked.
- Choose refresh timing deliberately. Enable refresh-on-open only where the source type and Excel edition support it, and explain to users when a manual Refresh All is still required.
What is the fastest troubleshooting decision tree?
Ask these questions in order:
- Did you run Refresh? If not, refresh the selected PivotTable.
- Are the missing records inside the defined source? If not, change the source range or use an Excel Table.
- Does refresh show a connection or query error? Check availability, permissions, saved source files and table or column names.
- Does the refreshed report show
#SPILL!? Clear the obstruction or relocate the PivotTable. - Is the report expected to update automatically? Check refresh-on-open and Auto Refresh availability for the source type, Excel version and platform; OLAP sources and non-Insider builds may not expose the same options.
Following those branches identifies whether the failure is a missing command, an incomplete range, an unavailable source, a changed schema, a timing limitation or a blocked worksheet. Each cause has a different remedy, so changing unrelated PivotTable settings is usually unnecessary.
How we selected the fixes
The sequence follows Microsoft’s documented distinction between refreshing an existing PivotTable, changing its source table or cell range, configuring refresh options, repairing external connections and clearing a #SPILL! obstruction. It prioritizes the least disruptive action—Refresh—before source changes or rebuilding, and it qualifies automatic-refresh advice by platform, source type and Microsoft’s stated Insider availability.
Frequently Asked Questions
Can I refresh a PivotTable without refreshing every other report?
Yes. Select a cell in the specific PivotTable and use Refresh, or press Alt+F5 in supported desktop Excel. Refresh All is broader and also runs other refreshable workbook connections, so it may take longer and expose errors unrelated to the report you are investigating.
Why are rows I typed below an Excel Table still missing?
Those rows may not actually belong to the Table. Check the Table’s resize boundary and enter the records in its next row, then refresh the PivotTable; data merely placed underneath an unrelated range is not included in the Table source.
Recommended Free Tools
Will refresh-on-open work for an OLAP PivotTable?
Microsoft documents the refresh-on-open option as unavailable for OLAP sources. The setting also varies by Excel edition and platform, so an option visible for a local workbook table should not be assumed to exist for a cube connection.
What should I do if Power Query keeps showing the previous source-file contents?
Save the source workbook or file before refreshing. Microsoft notes that changes made while that source is open may not be included until the file is saved; after saving, refresh the query and then refresh the PivotTable.

