How to solve “Filename is not valid” error in MS Excel?

-
Today in this article I am going to discuss about the error that might occurs when you try to open or save your file in Excel. Have you guys ever got “Filename is not valid” error message while saving your file in Excel? This is the most common error that we usually came across in Excel. This error can occurs in many forms such as you might receive below error message:

“The file could not be accessed.”
Or
“The path you entered, '<filename>', is too long. Enter a shorter path.”
Or
“<Filename> could not be found. Check the spelling of the filename, and verify that the file location is correct. “

The meaning of all the above error messages is same. So if you receive any of the above error messages then try the solutions that I will discuss shortly in this article. Let's first find out the cause of this error.

This error mainly occurs if you have given a very long name to the file while saving it. Suppose you have given a 255 characters long file name then you will receive below error message:
 “The path you entered, "<path>", is too long. Enter a shorter path.”

If you have saved the file by entering more than 255 characters then you will receive below error message:




Keep in mind: The path of the file including its name should not exceed 218 characters. Consider the following:
  1. You can include maximum 31 characters in a Excel sheet name.
  2. One exclamation point and one cell reference.
  3. Brackets and apostrophes to denote the workbook name.
Solution:
MS Excel provides a facility through which you can get more information about the error message. In Excel 2007, press Ctrl+Shift+l to know more about error.

To solve the error try following:
  1. Rename the file and give it a short name.
  2. Rename the folders that containing your file and give them a short name.
  3. Move your file to a different folder having a shorter path name.   
Note: The path of the file should contain less than 218 characters.

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