Checklist

9 signs your Excel file is no longer enough

Excel is an excellent tool. The problem is not Excel, it is what we end up asking of it: running part of the business. Here are nine signs your file has outgrown its role. Count the ones that apply to you: at the end, your score tells you what to do.

1. Several versions of the same file are circulating

"Tracking_2026_final_v3_REAL.xlsx." When the file travels by email, everyone works on their own copy and nobody knows which one is right. Decisions then get made on outdated numbers.

2. Only one person really understands the file

They built the formulas and know which cells not to touch. When they are on vacation, everything waits. If they leave, the knowledge leaves with them.

3. You copy the same data somewhere else

The customer is entered in Excel, then in invoicing, then in accounting. Every re-entry takes time and creates a chance for error. See ending double data entry.

4. A mistake has already cost you money

A wrong price in a quote, a forgotten invoice, a duplicate order. Spreadsheet errors are well documented: researcher Raymond Panko, who compiled audits of real business spreadsheets, reports that the most rigorous audits found errors in at least 86% of the spreadsheets examined (24% when older audits with less strict methods are included).

And in 2013, researchers at the University of Massachusetts showed that a spreadsheet error had left five countries, including Canada, out of a widely cited economic study on public debt.

5. The file is getting slow or crashing

An Excel worksheet can hold up to 1,048,576 rows and 16,384 columns. But long before that limit, a workbook full of formulas, lookups, and formatting becomes slow to open and recalculate, and more fragile.

6. You cannot control who sees what

Margins, salaries, or a customer's data sit in the same file as everything else. In Excel you can protect a sheet, but roles such as "sales reps see their own customers, managers see everything" are hard to manage.

7. Nobody knows who changed what, or when

An amount changed. Who changed it, and why? Without a reliable history, there is no way to know, or to roll back cleanly.

8. Several people need to edit it at the same time

For several people to edit the same workbook at once, Microsoft requires it to be saved in OneDrive or SharePoint Online. Even then, when ten people type in the same rows, conflicts and overwrites become common.

9. Your teams or customers need it outside the office

The technician on the road, the customer who wants to know where their order stands: a file on a desktop or a network drive does not serve them well. See the client portal.

Your score: what to do now

What to do based on the number of signs you checked
Signs checked What we recommend
1 or 2 Improve the file: structured tables, validation lists, protected sheets, and a single file shared in OneDrive or SharePoint instead of copies sent by email.
3 to 5 Look at a no-code tool or specialized software, especially if your process is common in your industry.
6 or more Your file has become software, without the safeguards. Custom software is worth evaluating.

The five options, with their real prices, are compared in our guide replacing Excel with software: options and costs.

Our take

Keeping Excel is not a mistake. Keeping it for a job it has outgrown is, and often a costly one. If you checked six signs or more, show us your file and we will tell you honestly which option makes sense.

Sources

  1. Microsoft: Excel specifications and limits
  2. Microsoft: collaborate on Excel workbooks at the same time with co-authoring
  3. Raymond R. Panko, "Spreadsheet Errors: What We Know. What We Think We Can Do," EuSpRIG 2000
  4. Herndon, Ash, and Pollin, PERI Working Paper 322, University of Massachusetts Amherst, 2013 (PDF)

Sources checked on November 12, 2026. Programs and prices change, so always check the official page before you decide.

Common questions about Excel's limits

How many rows can Excel hold?

An Excel worksheet can hold up to 1,048,576 rows and 16,384 columns, according to Microsoft. In practice, a workbook loaded with formulas slows down well before that.

Can several people work in the same Excel file?

Yes, if the workbook is saved in OneDrive or SharePoint Online: that is Microsoft's requirement for co-authoring. Beyond a few people editing the same data, conflicts become common.

Are Excel errors really that common?

Yes. The audits of real spreadsheets compiled by researcher Raymond Panko found errors in a large share of the files examined: at least 86% in the most rigorous audits.

Do we have to replace everything at once?

No. You can start with the most critical process and run the file and the new tool side by side during the transition.

What should replace Excel?

It depends on your score: improve the file, adopt a no-code tool, buy specialized software, or have custom software built. Our options guide compares their prices.

Did you check more than five signs?

Show us your file. We will tell you which option makes sense, even if it is not ours.