Autosave not working - no files are there

Anonymous
2014-01-12T05:27:19+00:00

I use autosave and have it set for every time minutes. I had a workbook open and was inputting data for many hours. I saw the taskbar show it autosave many, many times until it crashed. When I reopened excel, it reverted back to the last user saved version which was several hours old. I searched for the autorecover files, but they are the same old file. When I tried opening one, I get the error that happeend when it crashed - it says 'Excel cannot complete the task with available resources. Choose less data or close other application" (this was the error when it crashed in the first place)

I have plenty or memory available on my computer

I really need this fixed. Autosave does me no good if I can't recover my files.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

51 answers

Sort by: Most helpful
  1. Anonymous
    2018-02-14T19:08:23+00:00

    You are not the only one. I've seen several posts where people are having problems with autosave not working, causing them to lose hours of work.

    Right now it seems that going old school is the way to go. Use macros and 3rd party tools to do local Save As. Then manually move files to onedrive. It sucks, but until MS stabilizes their autosave we are exposed to crash problems.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-02-14T17:43:23+00:00

    I noticed that the auto save (and saving in general) documents that are auto syncing/backing up real time (drop box or similar) seems to have more problems just to my local computer.  Not sure if anyone else has seen this pattern or if I just got lucky...Possibly a file locking issue?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-02-08T06:23:07+00:00

    I understand your frustration. I've been there, done that and I know better. I am constantly reminding others to do frequent saves and backup. But I know how it is to get into a groove and work "head down" for a long time

    As you've seen, you are not the only one with this problem.  Apparently MS does nto pay much attention to this forum.  Most to the work/support is provided by unpaid USER volunteers. Granted there are a few MS staffers, but not necessarily developers.

    MS has created a specific user channel called "Feedback". There are a few different ways of accessing it, depending on the specific application / operating system.

    wiki Feedback Hub-Send Feedback to MS Developers

    https://answers.microsoft.com/en-us/windows/forum/windows_10-windows_install/send-feedback-to-ms-developers/506e7654-8ced-405b-911e-c58d8f253069?tm=1517255319051

    This link above is to a “Forum Article” describing the various ways you can now submit “Feedback” directly to MS Developers and Managers.

    ********************************

    *******************************************

    ********************************


    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2018-02-08T03:04:20+00:00

    Why cant this damn program just SAVE AUTOMATICALLY!!  I wasted 1hr of work time. 

    Why do you work for an hour and not click save? Who walks away from their computer and doesn't click save? Since I was about 8 yrs old I knew to save often. Nobody to blame but yourself. I'm sure you've got years of precious work and photos on your hard drive that you've been meaning to get around to backing up too.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2018-01-23T05:39:44+00:00

    .

    I look forward to receiving a prompt response from Microsoft in reference to these problems.

    Don't hold your breath waiting for a response from official MS. Very few MS staff read this forum.

    I agree with what you said above. If you want developers and managers at MS to see your complaints use the Windows Feedback Hub to submit it:

    Feedback Hub- Send feedback to Microsoft with the Feedback Hub app <WIN><F>

    https://support.microsoft.com/en-us/help/4021566/windows-10-send-feedback-to-microsoft-with-feedback-hub-app

    There are real MS staff and developers who monitor all submissions to the UserVoice forums whether you submit them through the Feedback Hub, or by using the Feedback command built in to some MS applications, like Office 2016, or by using the appropriate link directly

    NOTE: BEFORE entering your feedback, ESPECIALLY when you have crash problems or driver problems where you are willing to share configuration information from your system, click on the link to “go to diagnostic and usage data settings”. This takes you to the settings dialog for “Feedback & Diagnostics”.  This dialog allows you to specify “Basic” or “Full”. Personally I prefer basic most of the time. But when it is display or driver issues it would be a good idea to set it to “FULL”.

    Note: make sure to click on “Problem” or “Suggestion” radio button at top of dialog. You can’t submit until one is selected.

    Note: After you input the description you are asked to pick categories to put the submission in to.  Clicking on the drop downs is slow and confusing. Instead, click on the “Show category suggestions” hyperlink. It often provides reasonable pairs you can select from.

    Note: there is a special check box for “problem with how text is displayed”

    Note: there is a special category for “Driver” issues

    Note: When you look at existing feedbacks there is a “Share” button near the top left side of the dialog to get a link to the suggestion. That button is NOT present when creating a new feedback.  You have to submit it, then in the Feedback Hub home you have to click on “My Feedback” at the very top of the screen and select “All Categories” just below that.  Then you can click on your recently submitted suggestion. Now, you can see the “Share” button to get a link you can post back to the forum so other people can comment and vote on the suggestion.

    This next link is a wiki with a collection of MS UserVoice.com sites I’ve encountered (I’m sure there are more):


    http://answers.microsoft.com/en-us/windows/wiki/windows\_10-desktop/ms-suggestion-box-sites-at-usdervoicecom/7397119c-6d48-49e6-8d94-7bd0a50d214f

    In addition, when you post a suggestion / complaint to UserVoice, if you have reached there by being guided while asking a question in a forum, please post a link back to your suggestion in UserVoice in the original Question. That way other people who see your original question because they are looking for the same fix can easily find your suggestion, vote for it and add supporting comments.

    ********************************

    Was this answer helpful?

    0 comments No comments