When Excel Stops Working for Enterprise Pricing

When costs rise, pricing teams have a limited window to respond before margins come under pressure. That window tightens as the pricing environment becomes more complex.

Zilliant’s whitepaper, The Spreadsheet Trap: How Excel Is Undermining Your Pricing Strategy, describes what happens when spreadsheets remain at the center of that process. Manual updates can slow cost responses, while files shared through email or network drives can produce competing versions and uncertainty over which one is authoritative.

There is no universal company size or SKU threshold at which Excel stops working for pricing. The breakpoint comes when the pace and complexity of pricing decisions outrun the organization’s ability to manage them quickly, consistently, and with enough control.

When Excel Becomes a Pricing Constraint

One of the clearest warning signs is slow cost pass-through. Spreadsheet-based pricing requires teams to gather, enter, check, and update data before revised prices can reach sellers or customers. Zilliant says delays can leave companies absorbing cost increases instead of passing them through quickly enough to protect margins.

Consistency becomes another challenge as more people and processes depend on the workbook. Files shared through email or network drives can produce multiple versions, conflicting edits, and uncertainty over which version is authoritative. Pricing teams can then spend time reconciling differences instead of making new decisions.

Governance can become harder as well. Excel has limited ability to enforce approvals or maintain the audit trails expected in controlled pricing environments. Weak data validation, unprotected cells, and manual data retrieval can add further risk when spreadsheets are effectively being asked to operate like enterprise systems.

How Arvedi’s Quoting Outgrew Its Spreadsheets

Italian steel manufacturer Arvedi reached the point where spreadsheet-based quoting was becoming harder to manage. Arvedi’s commercial teams had long relied on spreadsheets to configure offers and generate quotes. As quoting complexity increased, the company recognized that it needed a more consistent, visible, and controlled process.

The complexity went beyond maintaining a price list. Arvedi sells technically demanding steel products, and its quotes have to account for valid product configurations alongside raw material costs, production complexity, and customer-specific terms.

Arvedi moved that work into Zilliant CPQ, which guides users through valid configurations and applies structured, rule-based pricing. Arvedi chose Zilliant CPQ for its SAP integration and experience in steel manufacturing.

Zilliant reports that work that previously required days of spreadsheet back-and-forth could be completed in minutes, while a history of quote revisions and approvals became available within the system.

What Has to Replace the Spreadsheet

Once spreadsheet-based pricing starts to slow commercial decisions, companies need a process that can keep pace with changing costs and growing complexity. The replacement has to improve three things: governance, responsiveness, and integration.

Zilliant’s Pricing Plus shows what the transition can look like for companies beginning to move away from spreadsheets. Launched for businesses still relying on Excel, homegrown tools, or manual ERP pricing, it introduces structured pricing frameworks, draft-and-publish workflows, audit trails, and scenario analysis.

Zilliant presents the change as staged. Companies can first retire selected spreadsheets and establish more consistent base prices, then improve scenario testing and cost pass-through before developing a repeatable pricing process across teams and systems.

Integration becomes increasingly important as pricing matures. Zilliant CPQ can connect with SAP ECC and SAP S/4HANA, drawing on SAP data during quote creation. Quotes and sales orders can then flow back into SAP.

Moving beyond spreadsheets does not require separating pricing from the ERP environment. The objective is to connect pricing decisions with the systems that already hold the information needed to make and execute them.

What This Means for SAPinsiders

• Watch for business symptoms instead of spreadsheet size. Slow cost pass-through, competing versions, inconsistent prices, and weak approval visibility are stronger warning signs than a particular number of rows or SKUs. The issue is whether pricing can still move at the speed and consistency the business requires.
• Treat pricing as a business process. Once pricing has to coordinate changing costs, customer-specific terms, configuration, approvals, and repeated commercial decisions, the formula is only one part of the job. Workflow, governance, and visibility become essential to keeping pricing accurate and repeatable.
• Do not replace one silo with another. Moving beyond Excel should strengthen the connection between pricing and the systems that support commercial execution, including SAP, CRM, and CPQ. Excel can still play a role, but it should not remain the place where enterprise pricing is governed.