This is a story about working around a tool, not advancing your work. This financial controller is spending time and mental energy figuring out how to run Windows on a Mac just to get Excel to behave. That is not a workflow problem; it is a technology gap that shouldn't exist.
The core issue here is that the spreadsheet itself is the bottleneck. Large datasets, complex formulas, VBA scripts, and Power BI integration are not exotic requests. They are the daily reality of financial modeling and FP&A work. Yet the user is forced to consider virtualization, RAM allocation, and compatibility layers just to do their job. That is a sign that the tool has not kept pace with the work it claims to support. Running Windows through Parallels is a bandage, not a solution. It introduces latency, resource contention, and another layer of complexity that has nothing to do with financial analysis. The question should not be "How much RAM do I allocate to the VM?" The question should be "Why does my spreadsheet software demand this much infrastructure?"
What this user really needs is a spreadsheet that is native to modern hardware and modern data demands. An AI-native spreadsheet does not require you to manage operating system partitions to handle a pivot table. It does not make you choose between a MacBook Air and full functionality. It processes large datasets in place, handles complex formulas without crashing, and integrates with SQL and BI tools as a natural extension of the interface, not a separate environment. The fact that VBA is still a requirement tells you how old the underlying architecture is. The work has evolved. The spreadsheet has not.
The practical takeaway is this: if you are spending time configuring virtual machines instead of configuring your financial models, the tool is failing you. You do not need more RAM or a different operating system. You need a spreadsheet that treats your data as a first-class citizen, not a burden. Stop adapting your hardware to a legacy application. Find an application that adapts to your workflow.