06/12/2026
Most capital teams know their spreadsheets were never built for portfolio-level governance.
They keep using them anyway.
Not because Excel is bad.
Because Excel is flexible, familiar, available, and easy to justify.
Every finance team knows how to build a model in it. Every project manager can update a forecast without waiting on IT. It does not require a new system, a new budget, or a change-management plan.
For one project, that works.
The problem starts when one spreadsheet becomes forty.
Forty active projects means forty different files, forty different structures, forty different version histories, and usually forty different people who understand “their” model best.
At that point, Excel is no longer just being used for analysis.
It has quietly become the system of record for capital governance.
And that is where things break down.
A project spreadsheet does not roll up cleanly into a portfolio view.
A forecast change in one file does not automatically update the assumptions another team relied on months ago.
A version saved to a shared drive does not tell you whether it is the version the Investment Committee actually approved.
So teams compensate manually.
They pull numbers from each file.
They reconcile formats.
They chase updates.
They rebuild portfolio views.
They prepare IC decks over several days, often while hoping nothing changed between the last update and the final presentation.
This is not a people problem.
It is not even an Excel problem.
Excel does what it was designed to do: support individual analysis.
The issue is asking it to also manage approvals, assumptions, audit trails, forecasts, portfolio rollups, and governance across millions or billions in capital spend.
Most organizations do not consciously choose this operating model.
It happens gradually.
One spreadsheet becomes the template.
Then another project copies it.
Then another team modifies it.
Then reporting depends on it.
Before long, the capital process is running on a network of files no one fully owns and no one fully trusts.
The trigger point usually comes later.
An IC meeting where the numbers do not reconcile.
A post-investment review where the original assumptions cannot be found.
A new finance leader inheriting dozens of spreadsheets with no clear documentation.
By then, the workaround has been accumulating cost for years.
Not loudly.
But steadily.