Are you Unable to save your Excel file? Here is the solution

-
Yesterday I was reading Excel forums and observed that a common problem was bothering most of the users. Users were facing problem while saving their Excel files. So lets discuss it. Sometime you can not save your Excel file due to numerous reasons. The reasons are:
  • You are trying to save your Excel file to a location where sufficient disk space is not available.
  • Some anti virus program is creating problem.
  • You are trying to save a shared Excel file.
  • You are trying to save your Excel file to a network drive with restricted permission.
  • You have entered more than 218 characters in file path while saving Excel file.
  • Third party add ins


Backup before Troubleshoot: Now before discussing the solution, first I would suggest you to create a usable, saved version of your Excel file. It will help you in recovery of data if below methods fail. You can create backup by one on the following options:

Save with new name
1.Go to File-> Save As.
2.Give your file a new name.

Save in HTML format
1.Go to File-> Save As.
2.Now in the Save As Type dialog box, click Web Page and Ok.

Save in different file format
1.Go to File-> Save As.
2.Now in the Save As Type dialog box, save your file with .xlsx or .xlsm extension.

Resolve Excel save issue

Save your Excel file to some other location: Try to save your Excel file to a new hard disk, floppy disk or network drive. If you are able to save your Excel file that means your system has one of the following problem
  1. Antivirus is conflicting with your Excel file: If antivirus is installed on your system then uninstall it because its scanning process may conflict with Excel save process.
  2. Exceed file name limit: You have entered more than 128 characters in path while saving your Excel file.
  3. Disk space is not sufficient: Save your file to a disk that has sufficient space otherwise you won’t be able to save your Excel file.
Save a new Excel file at the original file location:
  1. First create a new Excel sheet.
  2. Go to File-> Save As.
  3. Save this file on the same location where you have saved your original Excel file.
If now you are able to save your file that means in the original file either you have entered a long file name or you file was in a shared mode.

Restart Windows in safe mode: If above two solutions fail then open your Windows in safe mode and then try to save your Excel sheet.

Comments

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob
Read more

How to resolve MS Access error “Cannot find the database you specified”?

-
Yesterday I had received an email from my friend regarding an error in MS Access. My friend was getting an error message due to which she was unable to open her Access file. Whenever she clicked on MS Access database shortcut to open her file, an error message pop ups on her screen. Initially I didn't understand the reason behind the error but after searching for hours on internet, I got the solution. The error was: “Cannot find the database you specified, or you didn't specify a database at all”.
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more