IBM Lotus 1-2-3

IBM Lotus 1-2-3, once the gold standard for enterprise productivity, is now a legacy risk. IBM officially withdrew support for Lotus 1-2-3 Millennium Edition and SmartSuite 9.x over a decade ago, meaning any remaining enterprise instances are running on unpatched, 'zombie' infrastructure financialpost.com. While there is no current 'per-seat' pricing because the product is end-of-life (EOL), the hidden costs for CFOs are astronomical, involving specialized maintenance of legacy OS environments (like OS/2 or Windows XP) and high security vulnerability risks.

Modern AI agents and LLM-powered spreadsheets are systematically replacing the core '1-2-3' pillars: calculation, database, and graphing. Tools like Microsoft Copilot for Excel and Google Gemini for Sheets now automate complex formula generation and data cleaning that previously required manual entry or fragile Lotus macros. Furthermore, AI-native platforms like Equals and Rows.com utilize integrated AI to pull live data from APIs, rendering the static, manual data entry model of Lotus 1-2-3 obsolete. For organizations still using Lotus macros for business logic, LLMs like Claude 3.5 Sonnet can now refactor legacy LotusScript or x86 assembly-based logic into modern Python scripts or SQL queries with high accuracy.

What remains difficult to replace is not the software's functionality, but the deeply embedded, undocumented 'tribal knowledge' locked within .123 or .WK4 files. Many legacy spreadsheets act as 'shadow databases' for critical operations in fields like treasury and environmental biology. AI agents can extract this data, but the validation of complex, decades-old logic requires human-in-the-loop (HITL) oversight to ensure that the AI's interpretation of legacy formulas aligns with current regulatory and business requirements.

Financially, the case for replacement is urgent. Maintaining a legacy environment for 50 users can cost upwards of $50,000 annually in specialized IT support and 'technical debt' interest, whereas a transition to Microsoft 365 with Copilot (approx. $30/user/month for the AI add-on) costs roughly $18,000 annually for 50 users. At a 500-user scale, the savings from decommissioning legacy servers and reducing manual data reconciliation labor can exceed $250,000 in the first year alone.

Our recommendation is an immediate 'Replace' strategy. Organizations should use AI-driven migration tools to scrape legacy data, convert macros to managed code, and move workflows to a cloud-native, AI-augmented stack. The risk of hardware failure or a security breach on unsupported Lotus software far outweighs the cost of a modern AI migration.