Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11You can make an Excel performance dashboard update when its source data changes, when you refresh it, or when you open the workbook—but those are different behaviors, and none automatically guarantees real-time updates. The right setup depends on where your data lives and which Excel version you use. For a workbook you maintain yourself, an Excel table with PivotTables is a straightforward route; for data you import or repeatedly clean, Power Query can connect, transform, and refresh it.
What “automatically updating” means in Excel
A dashboard brings key metrics into one visual view and may let people filter the results. Microsoft’s tutorial builds one with PivotTables, PivotCharts, slicers, and a timeline. The crucial distinction is what is being updated:
As an Amazon Associate I earn from qualifying purchases.
- Source data: A new or edited row in a workbook table changes the underlying data. That alone does not always recalculate a PivotTable summary.
- Summary data: A PivotTable must be refreshed to reflect changes in its source, unless an applicable automatic-refresh feature is available and enabled.
- Imported data: A Power Query refresh reconnects to its source and retrieves available changes, then reapplies the query’s transformation steps. It is not a promise of continuous or instantaneous updates.
Microsoft documents manual PivotTable refresh and refresh-on-open, and notes a newer Auto Refresh option for local workbook data that is currently available to Microsoft 365 Insider participants. Feature availability can vary by platform and build. See Microsoft’s PivotTable refresh guidance.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsChoose the refresh route that fits your data
| Situation | Practical route | What triggers an update |
|---|---|---|
| You enter or paste records into the same workbook | Excel table feeding PivotTables and charts | Refresh the PivotTable, use refresh-on-open where supported, or use the local-data Auto Refresh option if your Excel build offers it. |
| You import from files or a database, or repeat cleanup steps | Power Query, loaded to a table or Data Model, with summaries built on the result | Refresh the query manually or configure an available refresh setting; the connection must succeed. |
| You only need updates when someone asks for them | Refresh or Refresh All | A person initiates the refresh. |
| You want refreshed data when the workbook opens | Configure refresh-on-open for the relevant PivotTable or connection where supported | The workbook must be opened, and the source must be reachable and accessible. |
| You expect every local edit to appear immediately | Check whether the applicable PivotTable Auto Refresh feature is available in your build | Microsoft currently describes this newer option as available to Microsoft 365 Insiders; do not assume it is present in every release. |
Power Query can connect to and shape external data, load it into Excel, and periodically refresh it. Microsoft’s overview explains its capabilities and platform differences at About Power Query in Excel. Connector support, authentication, and refresh behavior depend on the source and Excel platform.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Define the performance board before building it
Decide what the board should help its audience do. Select three to six useful KPIs, then write down each metric’s formula, unit, time window, comparison period, and target or status rule. Those definitions are choices for your organization; Excel cannot decide whether a KPI or target is meaningful.
- Specify what counts in the numerator and denominator for rates.
- Choose whether comparisons use a previous period, a target, or another explicit baseline.
- Set a consistent date boundary, such as calendar month or a rolling period.
- Make units visible, such as dollars, orders, hours, or percent.
Prepare a dependable source table
Use one rectangular range: a single header row with stable column names and one record or item on each subsequent row. Avoid missing rows or columns, blank separator rows, and inconsistent date or category formats. Microsoft’s dashboard guidance emphasizes a complete source range with one row per record.
In Excel, select the source range and create a table using Insert > Table (or the equivalent command in your platform’s current ribbon), confirming that the range has headers. Give columns clear names such as Date, Category, Owner, Amount, and Status. A table is easier to extend as records are added than a manually fixed range.
Free tools Windows power users keep installed
One-click scans. No signup required.
If Power Query loads the imported results to a worksheet, add new manually maintained records to the original source—not by typing into the query output. A subsequent refresh can replace that output with the data returned by the query. Microsoft’s instructions for adding source data and refreshing are at Add data and then refresh your query.
Build summaries and dashboard visuals
Create PivotTables for the questions your KPIs answer
Select a cell in the source table and insert a PivotTable. Arrange fields to calculate totals, counts, rates, or comparisons that match your metric definitions. For a trend, put the date field in rows and the measure in values; for a category comparison, put the category in rows and the measure in values. Use separate PivotTables when the views answer different questions.
Add charts and filters
Build PivotCharts from the summaries where a visual comparison helps: line charts for trends and bar or column charts for category comparisons are common choices. Add slicers for categorical filters and a timeline for dates when supported by the Excel version and PivotTable setup. Connect a slicer to the relevant PivotTables so one filter can control multiple views, where the workbook configuration permits it.
Rank #4
Microsoft’s dashboard tutorial demonstrates a dynamic dashboard assembled from PivotTables, PivotCharts, slicers, and a timeline. Its example uses four PivotTables and charts; that is an illustration, not a required dashboard size. See Create and share a Dashboard with Excel and Microsoft Groups.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Set up and use refresh controls
Refresh when needed
For a PivotTable, select a cell in it and choose PivotTable Analyze > Refresh where that tab is available. To refresh workbook connections and supported summaries together, use Data > Refresh All. Ribbon names can differ slightly across Excel platforms and versions.
Refresh on workbook open
For a PivotTable, open its options or properties and enable the refresh-on-open setting if your Excel version exposes it. For an external query, inspect the connection’s properties for a refresh-on-open option. These settings update data when the workbook is opened; they do not keep it continuously current while closed or guarantee a successful connection.
Check local Auto Refresh availability
If you want a PivotTable based on local workbook data to react to edits without a manual refresh, check the PivotTable refresh controls in your exact Excel build. Microsoft’s current documentation describes Auto Refresh as a newer option available to Microsoft 365 Insider participants. Do not assume this setting exists in other builds or that it applies to every external connection.
Power Query platform differences
Microsoft’s Power Query overview lists Excel for Windows, Mac, and the web, but capabilities differ. It says Power Query is not supported in Excel 2016 and 2019 for Mac, and describes Mac refresh support for sources including TXT, CSV, XLSX, JSON, XML, SQL Server, and tables or ranges in the current workbook. The overview also notes that Excel for the web gained refresh from authenticated data sources in 2025. Check the overview for the current support details for your platform and source before relying on a particular connector.
Validate the board before sharing it
- Add a clearly identifiable test record to the source table or the upstream data source.
- Run the refresh method your readers will use: PivotTable Refresh, Refresh All, or the query refresh.
- Confirm that the expected KPI, summary, and chart change, and that unrelated summaries remain correct.
- Test slicers and the date timeline, including the first and last dates in the intended reporting period.
- Check for blank fields, duplicate records, inconsistent categories, and date values stored in an unexpected format.
If a new record does not appear, check whether it was added inside the source table or upstream file, whether the PivotTable source includes it, and whether the query or PivotTable was actually refreshed. If a refresh fails for external data, check that the source is available and that the workbook has the needed access or authentication.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
