How to Fix Broken Excel Links and Formulas
If you’ve ever opened an important spreadsheet only to see:
#REF!
#VALUE!
#N/A
or a message saying:
“This workbook contains links that cannot be updated.”
…you’ll know how frustrating broken Excel reports can be.
For many SMEs, these aren’t occasional problems.
They’re part of everyday life.
One formula is accidentally overwritten.
A worksheet is renamed.
A file is moved to another folder.
A linked workbook is deleted.
Suddenly, reports that the business relies on no longer work.
The worst part?
You often don’t realise until someone questions the numbers.
Why Excel Reports Become Fragile
Most business spreadsheets don’t start out complicated.
They evolve.
A new column is added.
Another worksheet is created.
Someone links to another workbook.
A new report is copied from an existing one.
Over several years, what began as a simple spreadsheet becomes a network of interconnected workbooks.
Eventually, nobody fully understands how it all fits together.
One small change can break dozens of reports.
The Hidden Cost of Broken Spreadsheets
When an important workbook breaks, work usually stops.
Someone has to investigate.
Someone has to repair formulas.
Someone has to compare figures with previous reports.
Sometimes the original author is no longer with the business.
Sometimes nobody knows how the spreadsheet actually works.
One Financial Controller told us:
“Every time Excel asked if we wanted to update external links, we held our breath.”
That uncertainty is surprisingly common.
Why This Happens
Excel is an outstanding analysis tool.
But it wasn’t designed to become the backbone of a company’s reporting process.
When businesses depend on:
- Linked workbooks.
- Complex formulas.
- Nested IF statements.
- VLOOKUPs and XLOOKUPs.
- Power Query refreshes.
- Macros written years ago.
- Files stored in different locations.
…small changes can have unexpected consequences.
The spreadsheet becomes business critical.
But increasingly difficult to maintain.
Your ERP Already Contains the Data
Whether you use Sage, Microsoft Dynamics 365 Business Central, Exchequer, Pegasus Opera, Dynamics NAV, SAP Business One, Xero, Access Financials, Intact, Brightpearl, Oracle NetSuite or another ERP system, your business data already exists in a structured, reliable database.
The problems usually begin after someone exports that data into Excel.
That’s when formulas are added.
Links are created.
Manual calculations appear.
Over time, the spreadsheet becomes more complex than the system it reports on.
A Real Customer Story
A manufacturing business contacted Illuminis Insight Software after a workbook used for monthly reporting stopped working.
The spreadsheet had been developed over several years.
It linked to multiple exports from Sage.
Several worksheets depended on external files.
The original author had left the business.
Nobody wanted to make changes because they were worried about breaking it further.
When we reviewed the workbook, we found hundreds of linked formulas spread across multiple files.
Rather than repairing the spreadsheet again, we automated the reporting process.
Using Octelas, data was extracted directly from Sage and the calculations were moved into a controlled reporting platform.
Managers continued receiving the same reports.
But without the fragile workbook behind them.
The Finance Director later told us:
“We stopped fixing spreadsheets every month and started trusting the reports again.”
Fixing the Formula Isn’t Fixing the Problem
Many businesses spend years repairing Excel workbooks.
Someone fixes a broken formula.
Another person reconnects a missing link.
The report works again.
Until the next problem appears.
The spreadsheet isn’t the real issue.
The issue is relying on a manual reporting process that depends on one complex workbook.
Keep Excel for Analysis
We’re not suggesting businesses should stop using Excel.
Excel is still one of the most powerful tools available for:
- Ad-hoc analysis.
- Budget planning.
- Forecasting.
- Financial modelling.
- Exploring business data.
But recurring reports shouldn’t depend on fragile formulas and linked workbooks.
Those processes should be automated.
That way, Excel becomes a tool for insight rather than maintenance.
Reduce the Risk, Not Just the Symptoms
At Illuminis Insight Software, we rarely begin by asking how to repair a spreadsheet.
Instead, we ask:
- Why is this workbook needed?
- Where does the data come from?
- Which calculations are genuinely important?
- Which manual steps could be automated?
- Could the report be produced without relying on complex formulas?
Often, the answer is yes.
And once the process is automated, the business no longer has to worry about broken links, overwritten formulas or hidden errors.
Build Reporting You Can Trust
Your reporting shouldn’t depend on whether one Excel workbook still works.
Octelas, developed by Illuminis Insight Software, automatically extracts and combines data from Sage, Microsoft Dynamics 365 Business Central, Exchequer, Pegasus Opera, Dynamics NAV, SAP Business One, Xero and many other ERP systems to create reliable, automated reports that don’t rely on fragile Excel formulas or linked workbooks.
Instead of spending time repairing spreadsheets every month, your teams receive accurate reports built on trusted data, allowing finance, operations and management to focus on analysing performance rather than fixing broken files.
That’s why businesses across manufacturing, wholesale, distribution, engineering, construction and professional services choose Illuminis Insight Software as their trusted reporting and data partner—because business-critical reporting should never depend on a formula hidden in cell AZ274.