Windows 10: Why did Excel not save?

My company just made the switch From Google to Microsoft. We now have the Microsoft suite ("for work or school" I think). I was working on an Excel file for a few hours yesterday, but this morning it shows only the first 15 min of work. I turned on auto save after creating the document. Did it move somewhere else when I did that?

 

excel not auto recovering and manually saving

Hi,

The concern you have encountered with Excel not auto saving may be due to a corrupted file or a misconfigured setting.

May we ask if you have 3rd party software running when using Excel? If yes, we suggest to temporarily disable it to isolate the issue.

Any changes made on your computer prior to the issue?

Have you tried any possible troubleshooting steps? If yes, what are those steps and did you get any error messages?

You can turn-on the auto save option by the following steps:

• Open Excel
  
• Go to File then Options
  
• Under Save option, check the 'Save AutoRecovery information in every' option
  

the best way to check when auto save is disabled is to hover over the toggle and read the reason that the popup tool tip identifies. Simply follow the steps provided in this

article.

According to this
article the autosave function will be disabled when the file is in the old file format .xls.

Kindly keep us posted with the results.

Regards.

 

Excel Workbook Not Saving with Password

Hi 54646415,

Thank you for posting in Microsoft Community.

I understand that you're having trouble saving an Excel workbook with a password in Microsoft 365. Just a heads up that in regards to this kind of issue, our option is limited and we can only perform basic troubleshooting steps. Please allow me to ask some questions to better understand your concern.

• May I know what version and edition of Office installed in your computer? Is it for Business or for Consumer?
  
  • You can open any Office apps
    
  • Go to File > Accounts - on the right side you can see Product Information
    
• Is this happening to all of your Excel Document?
  

One possible reason for this issue could be that the file is being opened in read-only mode by another user, which is preventing you from saving the file with a password. To resolve this issue, you can try the following steps:

• Try saving the file to a different location, such as your desktop, and see if you are able to save it with a password there. If you are able to save it with a password in a different location, the issue may be related to the server or network.
  
• If the issue persists, you may want to try repairing or reinstalling Microsoft 365. To do this,
  
  • Open the Start menu and click on Settings.
    
  • Click on Apps.
    
  • Scroll down and find Microsoft Office in the list of installed apps.
    
  • Click on Microsoft Office and select Modify.
    
  • Select Quick Repair and click on Repair.
    

• Ask all other users to close the Excel file and ensure that no one else is accessing the file.
  
• Open the Excel file and enter the password to unlock the file.
  
• Click on the "File" tab and select "Save As."
  
• In the "Save As" dialog box, select the location where you want to save the file and enter a new file name.
  
• Click on the "Tools" dropdown menu and select "General Options."
  
• In the "General Options" dialog box, enter a password in the "Password to modify" field.
  
• Click "OK" to save the changes and close the dialog box.
  
• Click "Save" to save the file with the password.
  

I hope this helps! Let me know if you have any other questions.

Regards,

John Lloyd

Microsoft Moderator

 

Cannot save an excel file to any location on C:

It sounds like you have Ransomware Protection turned on in Windows Security. You can check to see if it has recently blocked your Excel. See Option One in this tutorial, at Step 5 click 'Recently blocked apps'. If Excel appears there, add it to the list of allowed apps.

Add or Remove Allowed Apps for Controlled Folder Access in Windows 10