Multiple users work on 100+ Gigabyte-sized Excel files. Every so often a file won't open and states its corrupted. Generally have latest OS, Microsoft 365 and mainly accessed from a Mac. One user has an old PC which cannot save >1.0Gb files. He found the latest corrupted file version though I have restored 4 versions going back in time without success. Already this means losing 3-4 days off work. This is costing us lots of time and money.
Any thoughts? All suggestions gratefully received.