When working in a workbook, Microsoft Excel saves the files automatically. It saves the file giving it a temporary file name and stores the file with the same folder along with the original version. When you manually save the file, the original file gets deleted, and the temporary file is saved with the name of the original file. Due to any interruption, the excel sheet might not save correctly. You might end up getting one or many temporary files in the same folder where you tried to save your file. Furthermore, you might get alerts or error messages. Excel issues might arise when trying to save excel workbooks. This applies to your excel for Office 365, Excel 2019 and even to Excel 2016.
1: Try saving the workbook by giving the file a new name.
2: Try shifting the original worksheets to a new workbook
3: Change the excel file type while saving the file.
4: Try changing the workbook location while saving the same.
5: Use the original location when saving a new workbook.
6: Use safe mode while saving the workbook.
In case you are facing a problem in saving the workbook when running Microsoft Excel in Windows Safe mode, Then most probably the problem might be caused by the side of a third-party add-in or the reason might be a file from one of the locations of an Excel startup. By default, you will find that as soon as you start excel, startup files are loaded. Some add-ins from third-party software vendors work together with existing Excel features by design, and some are intended to enable a seamless transition when you use a third-party product. Usually, these third-party add-ins do not tend to intervene with the functionality of Excel. Although, some functions, like saving a file can be high flown. For testing and eliminating the possibility of a third-party Excel add-in or when a file is causing the problem of “saving” in Excel, just try saving the file in Safe mode.
To get more information about the safe mode of Microsoft Excel, press F1 in Excel and this will open the Help menu, you have to type-safe mode in the Search box, and then you have to select Search to view the topic. If these causes are not the case with you, or if you still can’t save workbooks, you can try the following solutions to save your workbook :
Try saving a new workbook to the original location. Try to save a new workbook to the original location
Click on the ”File menu”. Tap on the option “Save As”. A dialog box will appear, follow these steps to get the issue resolved: Click on the location where the original workbook was saved. You will find a File name box, there give a name to the new file. Click on the Save option.
Try using safe mode to save the workbook. Start by Restarting Windows using the safe mode,then try using your local hard disk to save the workbook. Add Ons Our recommendation to you is that, just activate “AutoSave”, if you want to get rid of the problems that hinder the correct file saving. If case you are experiencing certain problems while using Excel, visit the following website and get more information about the version of your program.
If one or more conditions, from the following conditions are true in your case, the you might be having problems in saving a Microsoft Excel workbook. In case you have saved your workbook on a network drive, on which your system is having restricted permissions. If you have saved an Excel workbook to a location, having insufficient storage space. Lost connection of the Excel workbook. There might be an issue related to an antivirus software program. You might have saved a shared Excel workbook. If you have tried all the troubleshooting options but still getting the error, try contacting the office 365 help desk.