Forum Discussion

luny2ny's avatar
luny2ny
Copper Contributor
Jun 03, 2019

Data in ongoing worksheet disappeared over night

I use an ongoing Excel worksheet that I use on a daily basis. It was set up to auto save ever 5 minutes, I would save at the end of the day, and it was supposed to be set up to automatically save to ...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Jun 04, 2019
Not sure why you would set autosave to 5 minutes as files stored on onedrive already autosave? Unless you are using an older version of Excel, like 2013?
  • luny2ny's avatar
    luny2ny
    Copper Contributor
    Jun 04, 2019

    JKPieterse  Sorry, I misspoke, it was set up to save every ten minutes as a preset in Excel apparently as that was not set up by me. I switched it to five yesterday after I discovered the mess and was panicking. But 5 or 10...the autosave didn't work regardless, right? And neither did the onedrive apparently which is what I tried to communicate in my post. I never had to access onedrive until yesterday only to find it also was not doing what it was supposed to be doing. Basically I was wondering what happened to the two months of autosaves and manual saves (when working on it sometimes hours daily) in Excel and autosaves to the onedrive and if there was anything out of the ordinary that I could try to try and recoup it all.

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jun 05, 2019
      Can you add a screen-shot of where you set the 5 minutes save? I am guessing this is the autorecover setting, which is *not* a regular save!!!
      If you are using Office 365, files stored in OneDrive or on Sharepoint are saved an almost any change so saving is no longer needed. Backside of that is that you explicitly have to set documents you need to remain as they are (unchanged) to read-only (or turn off their autosave setting using the button on the Quick Access Toolbar.
      • cjadminologist's avatar
        cjadminologist
        Copper Contributor
        Mar 10, 2022

        JKPieterse 

         

        Urgent help needed 3/10/22

        Similar to what's reported here, I used excel to prepare my taxes inputting something every day.  It was complete yesterday and I opened the document this morning and everything has disappeared.  Recovery does not work.  Same **bleep** thing happened last year.  What happened?