For a surprising number of manufacturers, the quoting process does not live inside a CRM, ERP, or purpose-built system. It lives inside an Excel workbook that has been passed around, modified, patched, and protected for years.
The file usually looks harmless. Something like Quote Calculator Final or Pricing_Model_v12. But inside are hundreds of decisions layered over time: pricing formulas, freight assumptions, tooling logic, customer specific exceptions, margin adjustments, manual overrides, and workarounds added by different departments trying to solve immediate problems.
At some point, the spreadsheet stops being a tool and quietly becomes fragile infrastructure.
Despite the risk, nobody wants to disrupt a process tied directly to revenue. So, the spreadsheet survives, even as the business slowly builds more dependency around it.
When the Process Starts Owning the Team
The biggest issues usually do not come from a major spreadsheet failure. More often, the process becomes gradually harder to manage as additional checks, exceptions, and workarounds get layered over time.
Sales reps begin double checking formulas before sending quotes because they are not fully confident in the outputs. Finance spends extra time reviewing margins and pricing assumptions that should already be standardized. Approval cycles slow down because certain calculations or customer specific exceptions are only understood by a few experienced employees. In some cases, multiple versions of the spreadsheet start circulating because teams are hesitant to overwrite the file everyone depends on.
Newer employees often struggle the most because much of the quoting process exists outside formal documentation. Experienced team members know which fields can be adjusted, which calculations require additional review, and which long-standing customer exceptions still need to be considered. That knowledge is typically learned through experience rather than through a clear, repeatable process.
Over time, the quoting process becomes less dependent on systems and more dependent on specific people.
That dependency creates bottlenecks everywhere. Quotes sit waiting for approval from the few employees trusted to validate pricing. New hires take longer to ramp up. Customers wait longer for responses. Internal confidence in the numbers starts slipping, even if nobody says it out loud.
Eventually, the spreadsheet that once helped the business move faster starts slowing it down.
The Breaking Point
One manufacturer we spoke with knew their quoting process had become too dependent on Excel. The challenge was not identifying the problem. The challenge was figuring out how to improve it without disrupting the business.
Their sales team relied on a heavily layered workbook to calculate pricing across material costs, labor, tooling requirements, and customer specific variables. Over time, additional review steps had been added to reduce mistakes and protect margins, but those same safeguards were slowing the quoting process down and not always accurate.
As quote volume increased, more work started funneling through a small group of experienced employees who understood the spreadsheet best. Sales teams were reentering information multiple times; pricing assumptions were being manually reviewed before nearly every quote, and visibility into quote status became harder to maintain once requests were in progress.
Leadership believed response times were starting to impact opportunities because competitors were simply moving faster.
What made the conversation familiar was that the spreadsheet itself was not really the core issue. The larger problem was how much of the quoting process depended on manual effort, workarounds, and institutional knowledge that only existed in a handful of people’s heads.
Excel is not to Blame
The companies that improve quoting successfully usually do not start by replacing Excel. They start by understanding how quoting actually moves through the business.
Where does duplicate work happen? Which approvals create delays? What decisions rely on tribal knowledge? Which employees have become critical checkpoints simply because they understand the spreadsheet better than everyone else?
Those conversations tend to reveal the same thing: the spreadsheet is usually not the root problem. The process simply evolved faster than the systems supporting it.
Once teams can clearly see where friction, dependency, and manual effort exist, improvements become much easier to prioritize. Some companies eventually replace the spreadsheet entirely. Others improve the workflow around it first. In both cases, visibility comes before improvement.
Because the real goal is not just faster quotes. It is building a quoting process the business can scale without relying on one spreadsheet nobody wants to touch.
If your team is struggling with slow quote turnaround, inconsistent pricing, or a process that depends too heavily on a handful of experienced employees, it may be time to take a closer look at how quoting flows through the business. Sometimes the biggest opportunities for improvement are hiding inside the process everyone has learned to work around.