I have a question regarding the repair of Excel on Mac. I am an assistant in a company and I do some very very basic software work, amongst other things. My boss often deals with very large files (financial management, so lots of portfolio data, etc.) and recently he has been experiencing issues with Excel. It will shut down upon scrolling, tell him files are corrupted that had worked fine previously, all in all very annoying when it happens multiple times a day. Luckily we have multiple data backups, and so far nothing big has gone missing, but it is certainly tedious.
We have another company that functions as our tech support, and they recommended just updating all computers to the latest MAC OS x El Capitan, but to avoid Sierra when it becomes available. I had been planning on doing this anyways in the next few weeks, but any other things I should try? We haven't experienced issues on any other machine, and they all run on the same system. I already removed all preference settings in a hope that it might stop Excel from doing things it shouldn't, but that didn't help at all. Another thing I considered was a re-installation. All files are stored on an external server, which has plenty of storage. Cache and local storage are kept to the minimum as well.
What would you recommend? Thanks in advance!!