How to replace disconnected spreadsheets with managed workflows

Every growing company has one: the master planning spreadsheet that only one person really understands, emailed around as "v14_final_FINAL.xlsx", with hidden tabs, broken VLOOKUPs, and a macro nobody dares touch since the person who wrote it left two years ago. If that sentence made you wince, you already know the cost of running a business on disconnected spreadsheets — and this article will walk you through how to move off them without blowing up your operations in the process.

Why do spreadsheets take over a business in the first place?

Spreadsheets win because they're fast to start. A sales manager needs to track quotes, so they build a sheet. Operations needs to track stock levels across two warehouses, so they build another. Finance needs a cash flow forecast, so they build a third. Each one solves a real, immediate problem, and each one is built by someone who is not a software developer — which is exactly why it works at first and breaks later.

The breaking point usually looks like one of these:

• Three people have slightly different versions of the same "master" file, and nobody is sure which one is current.
• A formula gets overwritten by accident, and the error isn't caught until a customer complains about a wrong invoice.
• The person who built the sheet — with all its logic buried in cell references — leaves the company, and updating it becomes a small archaeology project.
• Data has to be copied by hand from the spreadsheet into another system (or the other way around), so the same order, stock count, or customer record gets typed twice.

None of this means spreadsheets are bad tools. It means they were never designed to be shared, audited, multi-user systems of record — and at some point every growing company asks them to be exactly that.

How do you know it's time to move off spreadsheets?

You don't need to rip out every sheet in the company. Some spreadsheets are fine forever — a one-off calculation, a personal to-do list, a quick what-if scenario. The signal to act is when a spreadsheet has quietly become a shared process, not just a personal tool. Concrete warning signs:

1. More than one person edits the same file regularly, and conflicts or version confusion happen at least monthly.
2. The sheet drives a decision with money attached — pricing, stock reordering, payroll, invoicing — where an error is expensive, not just embarrassing.
3. Someone has to manually re-enter data from the sheet into another system (accounting software, a webshop, a CRM) on a recurring basis.
4. You can't say with confidence who changed what, and when. There's no audit trail, just a modified-date and a guess.
5. Onboarding a new employee to "the process" means explaining an undocumented spreadsheet, tab by tab, instead of walking them through a system with clear steps.

If two or more of these are true for a given spreadsheet, it has outgrown Excel — even if nobody has said so out loud yet.

What is a "managed workflow" and how is it different from a spreadsheet?

A managed workflow is a process that runs inside a system with built-in rules, permissions, and a single source of truth — instead of inside a document that anyone can edit however they like. Concretely, the difference looks like this:

In a spreadsheet	In a managed workflow