Data Reverting in Excel Overnight

New Contributor

I am using Office 365 and I keep an Excel spreadsheet on my desktop with my sales contacts, follow-up dates, notes, etc. Recently, the daily changes I have made have been disappearing overnight. When I can remember I save a copy of my changes to the common drive. The next morning, the changes are still intact on the spreadsheet on the common drive but the copy on my desktop has lost the changes. I am currently not saving to One Drive and I suspect there is a setting that will correct this.

 

Also, when I connect to my computer via RDP from home, my document crashes and goes into document recover mode where I also seem to be losing some data.  Please 

1 Reply
I will add, if it is relevant, that the original spreadsheet was created using Apache Open Office, then saved as an Excel file.