Why managing formulas in Excel eventually breaks

Almost every supplement, cosmetic, and food company starts the same way: formulas in a spreadsheet. And for a while, it works. One product, one person who knows it, a few columns of ingredients and amounts. The problem is not that Excel is bad — it is that spreadsheet-based formula management has a ceiling, and you usually discover where that ceiling is at the worst possible moment. Here is exactly how, and why, it breaks.

The version problem

The first crack is versions. You tweak a formula and save a copy. Someone emails a variant. A file gets named final, then final_v2, then final_USE_THIS. Before long, no one is certain which version is the current, approved one — and a batch gets made from the wrong file.

Spreadsheets have no real concept of an authoritative current version with a tracked history. In a regulated industry where you must be able to show which formula a batch was made from, that is not a minor inconvenience; it is a compliance gap.

The drift problem

A formula is connected to a label, a spec sheet, a cost, and a set of compliance checks. In a spreadsheet, those connections are manual. You change a dose, and you have to remember to update the label artwork, recalculate the percentages, redo the cost, re-check the limits, and update the spec. Miss one — and people always eventually miss one — and the documents no longer match the product.

This drift is silent. Nothing warns you. You find out when a customer, an auditor, or a regulator finds the mismatch for you.

The knowledge problem

Spreadsheet formulas live in the heads of the people who built them as much as in the files. The logic of why an ingredient is at a certain level, which supplier it must come from, what the elemental content is — much of it is undocumented context. When that person leaves or is unavailable, the knowledge leaves with them, and the spreadsheet becomes a set of numbers no one fully understands.

The calculation problem

Spreadsheets calculate what you tell them to, with no understanding of meaning. They do not know that a mineral salt's weight is not its elemental content, that a percentage must be against a specific market's reference value, or that an allergen in a minor ingredient must be declared. So those calculations are set up by hand — and a copied formula error, a wrong cell reference, or an outdated reference value propagates everywhere, invisibly.

The compliance problem

A spreadsheet cannot check your formula against permitted ingredients, maximum levels, or claim rules, because it does not hold that regulatory knowledge. Every compliance check is therefore a manual, external task — repeated for every market and every change. As your product range and market footprint grow, the number of checks explodes, and the chance that one is skipped or done against stale rules grows with it.

The scale problem

All of these are survivable with one product. With twenty products across five markets, each revised periodically, the spreadsheet approach collapses under its own weight. The matrix of products, versions, markets, labels, and documents is simply too large to maintain by hand without errors — and the cost of each error rises as the business gets bigger.

What a purpose-built system does instead

Formulation software addresses each failure at its root. One authoritative version of each formula, with full history and approvals, so the version problem disappears. Labels, specs, costs, and checks derived from the formula, so they cannot drift. Knowledge captured as structured data on every ingredient, so it does not walk out the door. Calculations that understand meaning — elemental content, market-specific percentages, allergen roll-up — done automatically. Compliance checks built in and market-aware. And a system designed to handle many products, versions, and markets at once.

The shift is from a tool that stores numbers to a system that understands and manages your products.

When to make the move

The right time is usually just before the ceiling, not after a costly mistake. If you recognise the version confusion, the drift, the key-person risk, or the manual-check fatigue, you are already at the ceiling — the spreadsheet is working only because no one has hit the error that exposes it yet.

Where Lemoniq fits

Lemoniq replaces the spreadsheet with a system built for these products: one versioned source of truth per formula with audit trail and approvals; labels, specs, certificates, and costs generated from the formula so nothing drifts; structured ingredient data that captures the knowledge; automatic, meaning-aware calculations; a market-aware compliance engine; and the capacity to manage a full catalogue across many markets. It is the answer to every way the spreadsheet breaks.

The takeaway

Excel works for formulas until it doesn't — and the failures are predictable: versions, drift, lost knowledge, blind calculations, manual compliance, and the crush of scale. The question is whether you move before or after one of those failures costs you a batch, a market, or a recall. A purpose-built system removes the ceiling spreadsheets always have.

Lemoniq is the purpose-built system that replaces spreadsheet formula management — versioned, synced, compliant, and built to scale across your whole catalogue. See how it works