When opening an Excel spreadsheet, or using it as a template, a message displays that the spreadsheet is corrupted, or the spreadsheet does not open.
The corruption is not coming from FYI. It is happening within OneDrive and this is a Microsoft issue.
There are multiple reports of this error across the web, including this example in a thread on a Microsoft forum: https://answers.microsoft.com/en-us/msoffice/forum/all/onedrive-repeatedly-corrupting-macro-enabled/385043f9-4d1d-4502-89da-f3ee3c92f8d7
In the thread in this link, the Microsoft moderators suggested:
- "Transfer the contents across to a brand new file."
FYI Note: If the file is used in FYI as a template, also transfer it to a new template.
- "Turn off auto-save, so the user can control the saving."
FYI Note: Turning off auto-save can cause implications as you may lose data if you have an issue with your computer. This is not something that FYI would generally recommend. Therefore we recommend you only turn AutoSave "Off" on macro enabled spreadsheets.
When using Excel desktop, you use the AutoSave toggle in the top left-hand corner of the spreadsheet to set this to "Off" or "On".
Please note this may not help in every instance given that OneDrive is corrupting the files and FYI does not know about it.
Reverting to a Previous Version
If there are issues with a spreadsheet getting corrupted, FYI has the following functionality which give you the ability to revert to a previous version:
- Separate versions are automatically maintained within FYI.
- Versions are created whenever a user stops editing a file (with the I am finished editing button)
- In the document drawer, users can access the earlier versions and restore an older version and set it as the current version.
For details on versions in FYI, refer to Version History and Creating a New Document Version.