Working with Excel and VBA?

Excel workbook that nobody dares touch? We take it on.

Most of the workbooks that reach us were built by one clever person over many years, and that person has since left. We read the sheets and the VBA carefully, write down what it actually does, and get it running again without pretending the history isn't there.

  • Since 2015Fixing technology
  • FreeEstimates
  • US teamReal engineers

excel.log

still failing

What it is

Excel and VBA at a glance

Microsoft Excel is the universal spreadsheet, first released on the Mac in 1985 and on Windows in 1987. It is the tool almost every office worker already has, and the one people reach for when a problem needs numbers in rows and columns.

VBA, short for Visual Basic for Applications, has shipped inside Excel since the mid-1990s. It lets people who are not programmers automate real work, and over the years it has ended up running a surprising share of back-office processes: pricing models, financial consolidations, inventory, commission runs. More recent additions to the suite such as Power Query, Power Pivot, LAMBDA functions and Office Scripts cover much of the same ground with fewer sharp edges.

Type
Spreadsheet with embedded scripting
First released
1985 Excel, VBA 1993
License
Proprietary, part of Microsoft 365 Business or Family
Maintained by
Microsoft Corporation
Typically used for
Reporting, pricing models, consolidation, operational workbooks, custom office tools

The honest version

Excel and VBA pros and cons

No technology is all upside. This is where Excel and VBA earns its place and where it tends to cause trouble.

Where Excel and VBA is strong

  • Everyone already has itExcel is installed on almost every work laptop, which means a workbook can travel between colleagues, clients and auditors without anyone installing anything.
  • Instant feedbackYou change a cell and see the effect across the sheet right away. That short loop is why so many business ideas get prototyped here first.
  • Pivot tables and Power Query do real workYou can pull in a messy CSV, clean it, summarise it and chart it in an afternoon, with no code at all.
  • VBA lets a non-developer automate real tasksSomeone in finance or operations can record a macro, tidy it up, and save hours of manual work each week without waiting for IT.
  • Decades of examples onlineAlmost any formula or macro question has been answered somewhere already, often many times over.
  • Works offlineThe file is on your laptop. It opens on a train, in a hotel, or on a client site with no internet, exactly the same as it does at your desk.

Where Excel and VBA bites

  • A one-person system of recordA business-critical workbook usually lives on one person's drive, with no audit trail of who changed what. When that person is on holiday, nobody else knows which tab is safe to edit.
  • 32-bit and 64-bit behave differentlyVBA compiled on the old 32-bit Office runs differently on 64-bit Office. Any Declare statement that calls Windows needs PtrSafe and the right pointer types, or the macro breaks on the newer install.
  • No source controlVersions live as copies with names like Pricing_v7_final_FINAL.xlsm. Comparing two of them by hand is painful, and there is no clean history of why a formula changed.
  • Circular references and broken linksFormulas that quietly point at each other, or at a file on a share nobody maintains, are routine. The workbook keeps opening, but the numbers may be wrong.
  • Performance tanks past a certain sizeBeyond roughly a hundred thousand rows, or with heavy volatile functions, a workbook slows to the point of being unusable long before it hits any hard limit.
  • The security model blocks legitimate workbooksSince 2022 macros from the internet are disabled by default. Workbooks that used to just work now sit behind a warning bar, and users either learn to click through every warning or give up on the macro entirely.

Sound familiar?

Common Excel and VBA problems we fix

The Excel and VBA problems that bring people to us, and what you have once each one is fixed.

last maintainer: left in 2019

A business-critical spreadsheet with no maintainer

A workbook that quietly runs pricing, payroll or reporting, written years ago by someone who has since moved on. Nobody left can explain what each sheet does.

Documented, repaired, handed back

Run-time error '9'

The macros no longer work after an Office update

A VBA project built for an older version of Office that now fails on open, or raises errors the moment anyone clicks the button.

Working on current Office

PtrSafe required for 64-bit

64-bit Office breaks old VBA

Declare statements and ActiveX references written for 32-bit Office that crash or compile-fail the moment IT rolls out 64-bit Office.

Runs on 32-bit and 64-bit

calculation: 47 minutes

The file takes forever to open or recalculate

Volatile formulas across whole columns, giant lookup ranges, and array formulas copied far beyond the data. Each change triggers minutes of calculation.

Opens and recalculates in seconds

Links to external workbook are broken

External links point at files nobody can find

Formulas reaching across to workbooks on a share that was retired, or to a colleague's desktop that is no longer backed up.

Links traced, replaced or removed

macros disabled by policy

The Trust Center blocks the workbook

Mark-of-the-web on files from email or SharePoint, group policy settings, or an unsigned project that users no longer have permission to enable.

Signed, trusted and opening cleanly

row 1,048,576 reached

The spreadsheet has outgrown Excel

A workbook that was fine at ten thousand rows now has hundreds of thousands. It is slow, it crashes, and two people cannot edit it at the same time.

Moved to a real database or app

last backup: unknown

There is no reliable copy

The only version lives on a laptop, emailed around on request, with no history and no off-machine backup.

Versioned, backed up, restore tested

What we do

Excel and VBA help, from rescue to replacement

Call us for one stuck macro, or hand us the whole workbook.

Rescue
A workbook that will not open, a macro that errors on the first click, or a model that suddenly returns the wrong numbers.
VBA repair and modernisation
PtrSafe fixes for 64-bit Office, reference library repair, replacing retired features and signing the project so it is trusted again.
Performance
Trimming volatile formulas, fixing oversized ranges, moving heavy lookups to Power Query, measured before and after.
Documentation and handover
Reading the workbook end to end and writing down what it actually does, so the next person is not starting from zero.
Replacement
Moving a workbook that has outgrown Excel onto a proper database or a small web app, with the same inputs and outputs the business already trusts.
Managed Tech
Backups, scheduled checks and a team to call when the workbook misbehaves, on an ongoing basis.

How it works

From first message to fixed

  1. Look Free estimate

    Tell us what's going wrong. We look at it, then tell you plainly what's wrong and what it will cost.

  2. Fix

    We fix the cause, not the symptom. If something is down, getting it back up comes first.

  3. Harden

    Backups, monitoring, updates and access, so the same problem can't quietly come back.

  4. Hand back or stay on

    You get a plain-language write-up. Or we stay on for hosting, upkeep and new work.

Often found together

Running Excel and VBA alongside something else?

We work on the whole stack, so the problem can be wherever it actually is.

Questions

Excel and VBA questions

Something else? Call+1 737 727 7327

Can you rescue a business-critical Excel spreadsheet nobody maintains?

Yes, and this is most of what we are asked to do with Excel. We read the sheets and the VBA, write down what each part really does, fix the bits that are broken, and hand back a workbook you can safely change.

Why do our macros no longer work after the Office update?

Usually one of three things. A reference library that moved or was removed, the switch from 32-bit to 64-bit Office needing PtrSafe on Declare statements, or the Trust Center blocking macros from files that arrived by email or from a shared drive.

Can you move this spreadsheet to a real database or web app?

Often yes. We keep the inputs and outputs people already trust, move the storage and the heavy calculation into a proper database, and give users either a cleaner workbook or a small web form, depending on what fits their day.

Why is Excel so slow on this file?

The common causes are volatile functions across whole columns, lookup formulas pointing at huge ranges, array formulas copied far beyond the data, and external links to files that are no longer reachable. It is almost always several of these together.

Can you make our VBA work on 64-bit Office?

Yes. Declare statements get PtrSafe and the right pointer types, broken references are replaced, ActiveX controls are swapped where needed, and the project is signed so it opens without the warning bar.

How much does Excel and VBA help cost?

Estimates are free. Send the workbook, or describe what it does, and you get a price before any work begins.

Free estimate

Spreadsheet or macro giving you trouble?

Tell us what you're running and what's going wrong. A person reads it and comes back with an estimate.

  • No charge to find out what it will take
  • If it's urgent, say so

Replies come from a person. By sending, you authorize us to email you back. No marketing.