How to find errors across all excel sheets without go to special
- Step 1Save the workbook — Save in Excel so the file reflects the current state. The locator reads the saved file, not the live Excel session.
- Step 2Open the Error Locator — Go to the Error Locator — the Go To Special alternative. There's nothing to configure; the scan always covers every cell on every sheet.
- Step 3Upload the multi-tab `.xlsx` — Drop the workbook. SheetJS parses it locally and reads every sheet listed in the file, hidden ones included.
- Step 4See the cross-sheet count — The panel reports the total error count and the number of sheets spanned, then previews the first 10 as
[sheet] cell: errorType— instantly showing which tabs are affected. - Step 5Download the full multi-sheet report — Copy or Download to get every error grouped by sheet in the header line and listed line by line as
[sheet] cell: errorType (=formula). - Step 6Work the list tab by tab — Use the report as a checklist: jump to each
[sheet] cellin Excel, fix it, then re-upload to confirm the count falls to zero.
Error Locator vs. Go To Special → Errors
Why the locator is the better choice for any workbook with more than one sheet of formulas.
| Capability | Go To Special → Errors | Error Locator |
|---|---|---|
| Scans all sheets at once | No — active sheet only | Yes — every sheet in one pass |
| Lists cell addresses | No — selects cells only | Yes — [sheet] cell for each |
| Shows the formula | No | Yes, in the downloadable report |
| Covers hidden sheets | No — must unhide first | Yes — hidden tabs included |
| Distinguishes error types | No — selects all errors together | Yes — names each (#REF!, #N/A, …) |
| Copyable / downloadable list | No | Yes — text report |
What the multi-sheet report shows
The header line summarises the spread; each detail line localises one error. This is the inventory Go To Special never produces.
| Report part | Example | Meaning |
|---|---|---|
| Header count | Found 9 error cell(s) across 4 sheet(s) | Total errors and how many tabs are affected |
| Detail line | [Q2] D5: #N/A (=VLOOKUP(...)) | One error: sheet, cell, type, formula |
| Clean message | No formula errors found in this workbook. | Whole workbook is error-free |
Tier limits
Error Locator is free-tier. Limits are per file (Excel family); the number of sheets doesn't change the limit, file size and row count do.
| Tier | Max file size | Max rows | Files per run |
|---|---|---|---|
| Free | 5 MB | 10,000 | 1 |
| Pro | 50 MB | 100,000 | 5 |
| Pro + Media | 200 MB | 500,000 | 20 |
| Developer | 500 MB | Unlimited | Unlimited |
Cookbook
Multi-sheet reports in the tool's exact format. Note the header line that names how many sheets are affected — the cross-tab view Go To Special can't give you.
Errors spread across four quarterly tabs
A workbook with Q1–Q4 tabs, each driven by the same lookup. One report shows every affected tab at once — no fifteen-times repetition.
Report: Found 4 error cell(s) across 4 sheet(s): [Q1] D5: #N/A (=VLOOKUP(A5,Rates,2,0)) [Q2] D5: #N/A (=VLOOKUP(A5,Rates,2,0)) [Q3] D5: #N/A (=VLOOKUP(A5,Rates,2,0)) [Q4] D5: #N/A (=VLOOKUP(A5,Rates,2,0))
A hidden sheet Go To Special missed
The error lives on a hidden helper tab. Go To Special can't reach it without unhiding; the locator reports it by name.
Report: Found 1 error cell(s) across 1 sheet(s): [_Calc_Hidden] B17: #DIV/0! (=Total/Count)
Mixed error types across sheets
Where Go To Special would select everything as one undifferentiated blob, the report names each type so you can prioritise.
Report: Found 3 error cell(s) across 2 sheet(s): [Inputs] C8: #VALUE! (=B8*"x") [Summary] E14: #REF! (=Inputs!#REF!) [Summary] E15: #NAME? (=SUMM(E1:E14))
Confirming a whole multi-tab workbook is clean
After fixing each listed error tab by tab, one final scan confirms the entire workbook — every sheet — is error-free.
Report: No formula errors found in this workbook.
Many errors: use the full report, not the preview
With more than 10 errors the on-screen preview truncates, but the count is accurate and the downloaded report holds the complete cross-sheet list.
On screen: 23 error cell(s) found. [Data] A2: #VALUE! ... (preview shows first 10) Downloaded report header: Found 23 error cell(s) across 5 sheet(s): ... (all 23 listed with formulas)
Edge cases and what actually happens
Go To Special found errors this tool didn't
Check calculation stateGo To Special evaluates the live Excel session; the locator reads the saved file's cached values. If you ran Go To Special after edits without saving, save (and recalc with F9) before scanning so both see the same state.
Hidden and very-hidden sheets
DetectedThe scan iterates every sheet in the workbook's sheet list, including hidden and very-hidden tabs that Go To Special can't reach until unhidden. Errors there are reported with the sheet name.
Workbook has 50+ sheets
SupportedThere's no sheet-count limit — the scan walks them all in one pass. The only constraints are the per-file size and row limits, not how many tabs the workbook has.
More than 10 errors total
By designThe on-screen panel previews the first 10; the header count and the downloadable report cover every error across every sheet. Use the full report when many tabs are affected.
A cell holds literal '#N/A' text
Not detectedOnly cells with a true error type are reported. A literal text string #N/A is text, not an error, so it's skipped — the same way Go To Special wouldn't select it as an error either.
File over free 5 MB / 10,000-row limit
Blocked on freeLarge multi-sheet workbooks can exceed the free Excel limits. Upgrade to Pro (50 MB / 100,000 rows) or higher to scan the whole file at once.
Calculation set to manual
May miss errorsSheetJS reads cached results. If calc is manual and a sheet wasn't recalculated, an error may not be stored yet. Press F9 in Excel, save, then re-scan to match what Go To Special would show live.
Two workbooks dropped together
One file onlyThe locator scans a single workbook per run. To audit several files, scan them one at a time.
Encrypted workbook
Cannot parseSheetJS can't open an encrypted file without the password, so neither the multi-sheet scan nor Go To Special applies until you remove protection in Excel.
Frequently asked questions
How is this different from Go To Special → Errors?
Go To Special scans only the active sheet and just selects the error cells. The Error Locator scans every sheet in one pass and gives you a written list of each error's sheet, cell address, type, and formula — including errors on hidden sheets.
Does it really scan all sheets at once?
Yes. It iterates every sheet in the workbook, so a 15-tab file is fully audited from a single upload — no repeating the process per tab.
Will it find errors on hidden sheets?
Yes. Hidden and very-hidden tabs are scanned along with visible ones, which is something Go To Special can't do until you unhide them.
Does the report tell me the cell addresses?
Yes — each error is listed as [sheet] cell: errorType, with the formula added in the downloadable report. Go To Special only selects cells without listing addresses.
Can I copy the list into my own tracker?
Yes. Use Copy or Download to get the full plain-text report, then paste it into a checklist, ticket, or notes. The on-screen preview shows the first 10; the report has them all.
Why might Go To Special and this tool disagree?
Go To Special reads the live Excel session; the locator reads the saved file's cached values. Save and recalculate (F9) before scanning so both see the same state.
Is there a limit on the number of sheets?
No sheet-count limit. The constraints are file size and row count: free is 5 MB / 10,000 rows / 1 file, with higher tiers above that.
Does it differentiate error types like Go To Special?
It does better — Go To Special selects all errors together, while the locator names each type (#REF!, #N/A, #DIV/0!, …) per cell so you can prioritise.
Is my workbook uploaded?
No. SheetJS parses everything in your browser; the file never leaves your machine.
What formats can I scan?
Excel workbooks. The registry declares .xlsx; the picker also allows .xls and .ods. CSV isn't supported because it has a single sheet and no formulas or stored errors.
What if the workbook is huge?
Free tier handles 5 MB / 10,000 rows. For bigger workbooks upgrade to Pro (50 MB / 100,000 rows), Pro + Media (200 MB / 500,000), or Developer (500 MB / unlimited).
What pairs well with this for a full audit?
After listing errors, use the formula explainer to read a complex formula, the circular-reference finder for iterative loops, and the dependency map to trace precedents across sheets.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.