Stop fighting your spreadsheet. Start fixing it.

You opened Excel to finish one report. Two hours later you’re searching for “VLOOKUP returns #N/A even though value exists” and watching three videos that don’t quite match your situation. byyours is the library you wished you’d had at minute one.

Every guide on this site is written by a working spreadsheet professional, edited against a real failing workbook, and refreshed when Microsoft or Google ships a change that breaks the steps. No filler. No “have you tried turning it off and on.” Just the cause, the fix, and the comparison table you can paste next to your monitor.

Pick your problem

• Formula errors — #REF!, #VALUE!, #N/A, circular references, array spill collisions. Browse the formula library →
• Data cleanup — broken VLOOKUPs, hidden objects, checkbox glitches, import failures. Browse cleanup guides →
• Performance — slow files, calculation hangs, oversized workbooks, pivot refresh lag. Browse performance fixes →
• File corruption — won’t open, unreadable content, recovered file empty, crash on save. Browse recovery guides →
• Visualization — chart axes broken, conditional formatting weird, sparklines empty. Browse chart fixes →
• Collaboration — co-editing conflicts, version restore, permission errors, shared workbook breaks. Browse collaboration guides →

Why this library is different

Written by practitioners, not reposters. Our editorial team has spent a combined 30+ years inside accounting close cycles, financial modeling shops, and BI consultancies. We’ve watched the same five errors break the same five workbooks every quarter. The fixes here are the ones we actually use under deadline pressure.

Every guide is dated. Microsoft 365 and Google Workspace ship changes monthly. A fix that worked in 2022 can be wrong in 2026. We re-run the steps when the UI changes and stamp the date at the top of every article.

Comparison tables, not walls of text. Each guide ends with a “Wrong Way vs. Correct Way” table — a 30-second reference for the next time the error appears.

Independent. No vendor sponsorships. We don’t take payments from Microsoft, Google, or any add-in vendor. When we recommend Power Query, XLOOKUP, or migrating to Power BI, it’s because we use those tools ourselves — not because someone paid for the placement.

How to use this site

1. Search the exact error message (top right). 300+ guides indexed by both error text and underlying cause.
2. Skim the 60-Second Diagnostic at the top of each guide. Often the fix is in the first checklist item.
3. Apply the step-by-step. Screenshots and the exact menu paths.
4. Save the comparison table. Bookmark or print for the next time the same problem hits.

Free. No signup. No paywall.

Every guide on byyours is free to read. We’re supported by display advertising and the occasional affiliate link to tools we already use. If a guide saves you an hour, share it with the colleague who’s about to hit the same wall.

Read about our editorial standards → | Meet the team → | Send us a workbook problem →