The distinction that changes everything
By Hiran de Silva
For more than forty years, we have all talked about “spreadsheets” as though there were only one kind.
There aren’t.
There are two.
Understanding the difference between them explains almost every argument surrounding Excel, almost every case of so-called “Excel Hell”, and almost every claim that spreadsheets should be replaced by something else.
The distinction is simple.
There are Local Spreadsheets.
And there are Global Spreadsheets.
Everything else follows from that.
Where the spreadsheet came from
Long before VisiCalc, Lotus 1-2-3 or Excel, accountants already worked with spreadsheets.
They were pieces of paper.
Large landscape sheets used for calculations, reconciliations, budgets and analysis.
If they became too wide, we glued extra sheets together.
If they became too long, we used “brought forward” and “carried forward” totals.
Everything happened on that sheet of paper.
The calculations lived there.
The data lived there.
The logic lived there.
The physical sheet defined the limits of what was possible.
When electronic spreadsheets arrived, nothing fundamental changed.
The paper simply became electronic.
VisiCalc.
SuperCalc.
Multiplan.
Excel.
The formulas became magical because changing one number instantly recalculated everything.
But our thinking never really changed.
The spreadsheet was still the place where everything happened.
The only difference was that instead of carrying paper around the office, we carried files.
We still thought locally.
The Local Spreadsheet
A Local Spreadsheet is exactly what the original paper spreadsheet always was.
Everything lives inside it.
The data.
The calculations.
The reports.
The business process.
The user.
Even today, whether the file sits on your hard drive, on a network drive, in OneDrive, SharePoint or Google Drive, it is still fundamentally the same idea.
One spreadsheet.
One document.
One place where everything happens.
Cloud storage has changed where the file lives.
It has not changed the underlying mental model.
The spreadsheet remains the centre of the universe.
Most discussions about Excel assume this model.
Almost every Excel influencer demonstrates this model.
Almost every spreadsheet competency framework teaches this model.
Almost every criticism of Excel is aimed at this model.
And that is precisely the problem.
Business moved on
Meanwhile, the rest of the business world underwent a revolution.
Thirty years ago organisations began separating data from applications.
Customer information was no longer owned by Sales.
Invoices were no longer owned by Accounts.
Employee records were no longer owned by HR.
Instead, the data became central.
Applications became clients.
This became known as client-server computing.
Eventually it evolved into ERP systems, cloud services and enterprise architecture.
Business stopped moving documents around.
Instead, applications moved data.
One version of the truth.
One shared source.
Hundreds of applications.
Thousands of users.
Everyone working with the same live information.
Business became global.
Yet spreadsheets remained trapped inside the local model.
The Global Spreadsheet
A Global Spreadsheet is something entirely different.
The spreadsheet is no longer where the business lives.
The spreadsheet becomes one client among many.
Its job is no longer to own the data.
Its job is to retrieve data from the central store when needed.
To update that central store when necessary.
Nothing more.
Nothing less.
The spreadsheet becomes part of a much larger business process.
Accounting has one spreadsheet.
HR has another.
Procurement has another.
Sales has another.
Operations has another.
Every spreadsheet performs a different task.
Yet every one of them reads from and writes back to exactly the same business data.
Nobody emails spreadsheets around.
Nobody imports yesterday’s version.
Nobody wonders which copy is correct.
Everyone is working from the same live business reality.
The spreadsheets are independent.
The business is integrated.
That is a Global Spreadsheet.
This is not cloud storage
Many people believe they already have global spreadsheets because they use Google Sheets, SharePoint or OneDrive.
They do not.
Those technologies simply store the spreadsheet centrally.
Multiple people may open the same spreadsheet.
But it is still the same spreadsheet.
The spreadsheet remains the centre of the process.
A Global Spreadsheet is fundamentally different.
Different spreadsheets.
Different business functions.
One shared business database.
The centre is no longer the spreadsheet.
The centre is the business itself.
That is a completely different architecture.
Why this matters
Once you recognise the distinction, many longstanding arguments suddenly disappear.
“Excel doesn’t scale.”
Local spreadsheets often don’t.
Global spreadsheets do.
“Excel creates silos.”
Local spreadsheets do.
Global spreadsheets eliminate them.
“Excel causes version control problems.”
Local spreadsheets do.
Global spreadsheets don’t.
“ERP replaced spreadsheets.”
No.
ERP replaced isolated data.
Global spreadsheets fit naturally inside enterprise architecture because they work exactly the same way as every other client application.
The spreadsheet is simply another client.
Why Excel gets blamed
Almost every criticism of Excel is actually a criticism of Local Spreadsheet thinking.
The spreadsheet software gets blamed for problems created by an outdated mental model.
That is rather like blaming Microsoft Word because someone stored every company contract inside a single document.
Nobody would do that.
Yet organisations continue treating spreadsheets this way every day.
The problem is not Excel.
The problem is confusing Local Spreadsheet architecture with the only possible architecture.
My challenge to the spreadsheet community
I am not proposing another Excel feature.
I am not proposing another add-in.
I am not proposing another best practice.
I am proposing that we stop thinking of “spreadsheet” as meaning only one thing.
The spreadsheet world needs a new vocabulary.
Local Spreadsheet.
Global Spreadsheet.
Once that distinction exists, discussions become clearer.
Training becomes clearer.
Competency becomes clearer.
Enterprise architecture becomes clearer.
Even the phrase “Excel Hell” becomes clearer.
Because almost every horror story people describe turns out not to be an Excel problem at all.
It is a Local Spreadsheet problem.
A new mental model
Every technological revolution begins with a change in thinking.
Before Copernicus, people thought the Sun went around the Earth.
Before client-server computing, businesses thought applications owned their data.
Today, much of the spreadsheet world still thinks like it did in the age of paper.
That thinking made perfect sense in 1983.
It makes far less sense in 2026.
The future of spreadsheets is not about abandoning Excel.
It is about abandoning the assumption that every spreadsheet must be local.
Once you understand the difference between a Local Spreadsheet and a Global Spreadsheet, you do not simply see spreadsheets differently.
You begin to see business differently.
Add comment