I have come across a monstrosity of an Excel, while it does not make any sense in my opinion to have this Excel. Some of my colleagues at this large corporate are extremely fond of using it. Unfortunately, I am not allowed to make any changes to the Excel other than the sheets that are unlocked to me.
Despite me having a laptop with sufficient memory (32GB) and a normal AMD Ryzen 5 PRO 4650U CPU, I am having great difficulties editing the Excel as constantly everything seems to be stuck. I have unlocked the Excel and tried to analyse why the Excel is so slow and I think I have found the problem. In my opinion it is because of the volatile functions that they use in the data validation and extreme amounts of conditional formatting.
Therefore my obvious question, is there a solution to turn off conditional formatting and data validation temporarily and enable them when I close the Excel prior to sending them to my colleagues? Or am I hopeless and I have to ask the company to buy a new computer just for this Excel?
PS: if it matters, I am using Office 365 and I have disabled all plugins. Even in safe mode it is extremely slow.
Thanks in advance!
