Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

Excel limitations: problems, issues, disadvantages

Excel spreadsheets continue to be popular today. This is perfectly understandable, as they are a great tool for the collection and transformation of small amounts of data. However, if you work with large datasets, complex calculations, and references to external data, you may start encountering several issues.

Unfortunately, since complex analyses are becoming more and more common on high-volume data, and online collaboration has become crucial, you may feel that you have outgrown Excel. In this article, you’ll learn about 6 Excel limitations that continue to affect most users. Fortunately, tools like Sheetgo’s AI automations let you keep your existing Excel spreadsheets and connect them, so data moves between files without manual copying.

Excel limitations

In addition to the technical limitations and specifications published by Microsoft, there are some disadvantages and challenges associated with its use. Unfortunately, most of these challenges are related to aspects that are becoming increasingly important, like collaboration, keeping track of changes or versions of your spreadsheet, and of course, automation.

The technical specifications and limitations of Excel are well-documented, and details are available on Microsoft’s Support pages. Each sheet is limited to 1,048,576 rows and 16,384 columns, which gives us a total of 17,179,869,184 cells. However, if you actually try this, you’ll see that the worksheet becomes practically impossible to work with. Regarding the number of sheets allowed per workbook, the support page states that it is “Limited by available memory.” In other words, with a normal computer, you’re unlikely to be able to even approach these limits, whatever they may be.

1. Excel Online

If you’re using the online version of Excel, then you will face even more challenges, as it is a limited version of what is offered in the desktop application. Microsoft does a good job documenting the specifications and limitations of its products, so you can easily identify the differences between the two versions. There is a Microsoft Support article that covers those differences quite comprehensively.

However, a quick look will tell you that they are not the same tool. In addition to explanations about how certain features work similarly or in general, there is a specific section on the differences. There are issues related to important features, like controls, data connections, data validation, functions, and workbook protection. Add-ins, which are a common way to expand Excel’s features, are also very limited in the web version.

2. Co-authoring for collaboration

Microsoft 365 suite introduced users to Excel’s online version to compensate for previous online collaboration limitations, including the Excel Co-Authoring feature but failed to level up to the functionalities offered by the desktop version.

Change tracking is limited too: Excel’s Show Changes panel lists recent edits, but you can’t accept or reject them the way the old Track Changes feature allowed, so going back to a specific edit takes manual work. In terms of the “Comments” function, unless you provide clear instructions on how to use them, they can quickly turn into an instant messaging channel. The more co-authors work in a file at once, the slower Excel gets, and large shared workbooks can crash.

Broken cell references: Having several users working simultaneously can lead to accidental cell or formula changes. Although you can add filters for sorting and viewing data, it will affect the rest of the users who are working on the spreadsheet.

3. Version control

Keeping track of versions of your spreadsheet can be quite a nightmare. Even if you’re the only person with access to the spreadsheet, you can face some unexpected issues with versions created due to different issues with your spreadsheet; these include temporary loss of your internet connection, an unexpected crash of your workbook or operating system, loss of power, etc. These situations very often lead to “conflicts” with different versions of your file; ironically, they’re often caused by safety backup features intended to avoid any loss of data.

However, it’s very unlikely that you’ll be the only user with access to the spreadsheet, and the chances of losing track of the versions of your file increase with each user added.

4. Tracking errors

In addition to the challenge of tracking versions, there is the problem of tracking errors. There is really no way to keep accurate track of this. Error handling in Excel is something that users frequently complain about, as it can take a very long time to even find the cell with the error or the problematic formula, let alone fix it.

It is simply too easy to change things in your spreadsheet – accidentally swipe over a range, and you’ve suddenly moved a group of cells. If you’re lucky, you’ve moved it to cells that already contain data, so at least you’ll get a warning and be asked to confirm this action. Otherwise, you may not notice until you start getting strange results, hopefully not at the very end of the process.

5. Complex automation

When it comes to repetitive and time-consuming data tasks, the goal is clearly automation. All businesses have at least some processes that are frequently repeated and could be carried out automatically. While Excel has its Macros, they are quite limited. You can record simple actions, and as long as everything is in the same place and the same format, it will work as expected.

However, unless you make modifications to the macro, it’s not very useful for larger tasks involving logic or complex functions. And that’s the catch: to edit your macro, you need to know VBA and be familiar with the inner workings of Excel. This makes it very complicated for users to accomplish any meaningful automation with Excel alone. Sheetgo, an AI-powered data automation platform, can take over repetitive data transfers between Excel and Google Sheets files without code.

6. Data analysis

While there are add-ins that provide some data analysis capabilities to Excel, if you work with large amounts of data and want to perform complex data analysis, you will be disappointed. As mentioned previously, it’s not a great idea to work with very large datasets in Excel, as it has a tendency to slow down your entire computer. If you add complex calculations to the mix, you’re likely to be feeling frustrated in seconds.

Excel works well for basic correlations and regressions, but if you need more sophisticated data operations and analysis, you won’t get them in Excel.

10 disadvantages of Microsoft Excel at a glance

Here are the main Excel limitations in one list, including the hard limits Microsoft documents for each workbook.

  1. Row and column cap: each worksheet holds at most 1,048,576 rows and 16,384 columns.
  2. Cell size: a cell can contain at most 32,767 characters.
  3. Performance: large workbooks with many formulas get slow long before they reach those limits.
  4. Excel for the web: the browser version (Excel Online) lacks some desktop features, and it can’t run VBA macros.
  5. Co-authoring: real-time editing only works for files stored in OneDrive or SharePoint.
  6. Version conflicts: copies of the same file pile up and drift apart as more people edit them.
  7. Error tracking: a broken formula or a moved range can be hard to find across sheets.
  8. Automation: anything beyond a recorded macro needs VBA or scripting skills.
  9. Data analysis: advanced analysis needs add-ins or a separate tool.
  10. Linked data: links to other workbooks break when the source files are moved or renamed.

Conclusion

Excel still represents the most popular go-to solution for data storage, transformation, and visualization. However, as we advance further in the era of Big Data, the standard collaboration and automation features offered by Excel fall short of what is now required by most spreadsheet users.

You should now be more familiarized with the 6 main limitations that Excel has yet to overcome and be able to find alternatives to work around these while enjoying the full potential of Excel. Although Google Sheets presents a more affordable and intuitive solution when it comes to online collaboration, Google Sheets also has its limitations. To learn more about the main differences between Excel and Google Sheets, check out our post on Google Sheets vs. Excel – the biggest differences.

You may also like…

How to lock cells in Excel — Excel logo next to a green padlock on a mint background

How to lock cells in Excel? (cells, sheets & formulas)

Learn how to lock cells in Excel to stop accidental edits, plus how to protect a sheet and lock formulas, with steps for Windows and Mac.

Excel version control — stacked XLS file icon in teal on a dark navy background

The beginner’s guide to Excel version control

Discover what Excel version control is, the version control features Excel has to offer, and how to use them to share, merge, and review Excel changes.

How to remove password protection from Excel — Excel icon next to a padlock with a masked password on a light blue background

How to remove a password from Excel (multiple methods)

Learn how to remove password protection from Excel: unlock a file or a sheet when you know the password, and what to try if you’ve forgotten it.