Power Query Problems

How to Automatically Update an Excel Summary from Multiple Equipment Sheets

Anum MushtaqAnum Mushtaq Nov 13, 2026 868 views

Question details

The user needs an automatically updating repair summary when data is entered on equipment worksheets such as 245D or 325BL, without manually changing formulas for every new repair.

How to Automatically Update an Excel Summary from Multiple Equipment Sheets
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user maintains separate equipment worksheets for machines like 245D and 325BL and needs a summary sheet that stays current as repair records are added.
Observed behavior
Formulas or summary cells must be manually updated whenever a new repair is added to an equipment sheet.
Before you start

Before consolidating, check that every equipment sheet uses the same column order and headers, such as Equipment ID, Repair Date, Description, Mechanic, and Cost. Remove title rows or merged cells above the data so each sheet starts with the same header row.

Solution 1Recommended

Consolidate Equipment Repairs into One Excel Table and Summarize with FILTER

Best when you can simplify the data layout; one repair log table removes the need for per-sheet formula updates and makes the summary refresh automatically.

Separate worksheets for each machine make consolidation difficult because every new sheet or repair can require formula changes. A single repair table lets you filter, sort, and summarize all equipment records with a few static formulas.

1
Create the repair log table

Open a new worksheet named RepairLog and enter the headers Equipment ID, Repair Date, Description, Mechanic, Parts, Cost, and Notes.

2
Format the data as an Excel Table

Select the header row and any existing data, go to Insert > Table, check My table has headers, and name the table RepairLog in Table Design.

3
Enter the summary formula

On the Summary sheet, enter =FILTER(RepairLog,RepairLog[Equipment ID]="245D","No repairs found") to return all repairs for equipment 245D.

4
Add new repairs without changing the formula

Type each new repair as the next row in RepairLog. The table range and FILTER formula include new rows automatically, so the summary updates without manual formula edits.

Consolidate Equipment Repairs into One Excel Table and Summarize with FILTER
Summary updates automatically: When the data lives in one table, the summary references the table columns instead of individual equipment sheets, so new rows flow through without editing formulas.
Free Microsoft Office alternative

Use WPS Office as a Free Spreadsheet Alternative for Equipment Repair Summaries

WPS Office is a free, lightweight Microsoft Office alternative that opens and saves .xlsx workbooks, keeps familiar spreadsheet tools, and makes it easy to manage equipment repair logs with tables, filters, and formulas. Use WPS Spreadsheets as a practical alternative when Power Query is not available.

  1. 1. Download and install WPS Office: Go to the official WPS Office download page, download WPS Office Free, and install it on your Windows, macOS, or mobile device.
  2. 2. Open the existing equipment workbook: Launch WPS Spreadsheets and open the .xlsx repair workbook. The file opens in a familiar ribbon interface without converting the data.
  3. 3. Build a table- or PivotTable-based summary: Use Insert > Table to create the repair log, or use Insert > PivotTable to summarize Equipment ID, repair date, and cost without Power Query.
Free to download and use without a Microsoft 365 subscriptionOpens and saves .xlsx workbooks so equipment repair files remain Microsoft Excel compatibleFamiliar ribbon interface and spreadsheet functions ease the move from ExcelLightweight and fast, even on business PCs with limited resourcesSupports Excel tables, filters, and formulas for repair summary workflows
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel automatically update a formula when a new repair is entered on an equipment sheet?

Excel does not need to change the formula itself. Use an Excel Table or Power Query so formulas and queries reference an expanding data range. For example, an =FILTER(RepairLog,RepairLog[Equipment ID]="245D") formula includes new rows automatically.

What is the cleanest structure for tracking repairs across machines like 245D and 325BL?

Put all repairs in one table with an Equipment ID column. Then use FILTER, sorting, or a PivotTable to create summaries by machine, date, or repair type without maintaining separate-sheet formulas.

How do I append separate equipment sheets into one refreshable summary in Excel?

Convert each sheet to an Excel Table, load one into Power Query, use Home > Append Queries > Three or more tables to add the other sheets, then use Close & Load To. Refresh the query after new repairs.

Does WPS Office include Power Query for consolidating worksheets?

WPS Office does not include the Microsoft Power Query add-in. You can still open Excel workbooks, use tables and formulas, or use the free WPS alternative for general spreadsheet work.

Why does my summary not include new rows even after I type more repairs?

Check that the new rows are inside the Excel Table or query source range. If the range is a fixed reference like A2:C100, extend it or convert the data to a table so new rows are included automatically.