Lỗi rename the file to use a shorter name năm 2024

If I tried to re-name the file in the desktop, it doesn't let me change longer ( It used to be okay).

However, if I re-named the file in the Dropbox Website, it let me change the name longer. ( it automatically changed the name in my desktop file too)

Then, I cannot open the file from the desktop until I rename to shorter or copy to additional file to rename shorter.

We couldn’t open that file. Rename the file to use a shorter name or copy it to a different folder with a shorter path.

We faced similar issues like: “Sorry, we couldn’t find . Is it possible it was moved, renamed, or deleted?”

“Cannot open the file because the full path of the file is too long. Please keep the full path less than 218 characters”

The file could not be accessed. Try one of the following:

• Make sure the specified folder exists.
• Make sure the folder that contains the file is not read-only.
• Make sure the file name does not contain any of the following characters: < > ? [ ] : | *.
• Make sure the file/path name doesn’t contain more than 218 characters.

Solution:

This is because the maximum URL length of Excel files can’t exceed 218 characters! Although SharePoint Online supports up to 400 characters in URL (and you can open any Excel file with > 218 characters length in Excel Online!), Client-side Office Applications like Excel still have a limit of 218 characters.

So, If you try to open or save any file with URL > 218 characters, you may get this error! To resolve this issue, rename the file or folder or move the file to some other folder location so that the total length of the file would be lesser than 218 characters.

Please note, this limit applies to the full path of the URL in the encoded form! E.g., Any space characters (or special characters) are encoded with three characters as “%20”. So, the URL “https://crescent-my.sharepoint.com/personal/salaudeen_crescent_com/Shared Documents/Assets & Inventory.xlsx” will be calculated by encoding it as “https://crescent-my.sharepoint.com/personal/salaudeen_crescent_com/Shared%20Documents/Assets%20&%20Inventory.xlsx”.

Word, PowerPoint, and Access also have a similar limitation of 259 Characters. KB articles addressing this issue:

• https://support.microsoft.com/kb/213983
• https://support.microsoft.com/en-us/help/325573/you-receive-error-messages-when-you-try-to-open-an-office-document

In contrary to the above, I found Excel files with up to 259 characters length just works fine!

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Em gặp tình trạng như sau các bác ơi : Chẳng là em có copy 1 file excel A từ folder B sang folder C ( đều trong cùng 1 phân vùng ổ cứng ), tuy nhiên khi mở file excel A đấy từ folder C thì báo lỗi là " Sorry,we couldn't find ...(link folder/excel A ). Is it possible it was moved,renamed or deleted ? ". Trong khi nếu vẫn mở file A đấy từ folder B thì vẫn mở bình thường ? Các bác cho em hỏi lỗi này xử lý như thế nào ạ ? Xin cảm ơn !

When you open or save a file in Microsoft Excel, you may receive one of the following error messages:

Error message 1

Filename is not valid.

Error message 2

The file could not be accessed.

Error message 3

The path you entered, '', is too long. Enter a shorter path.

Error message 4

could not be found. Check the spelling of the filename, and verify that the file location is correct.

Error message 5

In Microsoft Office Excel 2007, you may receive the following error message:

'.' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.

To verify the error message that you receive in Excel 2007, press Ctrl+Shift+I. The following number is displayed in the lower-right corner of this error message dialog box:

100202

Note Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages.

Note If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.

Cause

This error message occurs when you save or open a file if the path to the file (including the file name) exceeds 218 characters. This limitation includes three characters representing the drive, the characters in folder names, the backslash character between folders, and the characters in the file name.

This behavior is based on a 256-character limitation in Excel for creating links to another file. This limit of 218 characters for the path name is based on the following:

• Up to 31 characters in a sheet name.
• Apostrophes and brackets used to denote the workbook name.
• An exclamation point.
• A cell reference.

For example, the path for a file might resemple the following:

'c:\excel\personal\...\[my workbook.xls]up_to_31_char_sheetname'!$A$1

Note This behavior will also occur if there is a square bracket in the path.

What To Try

Make sure that the path to the file contains fewer than 219 characters. To do this, use one of the following methods:

• Rename the file so that it has a shorter name.
• Rename one or more folders that contain the file so that they have shorter names.
• Move the file to a folder with a shorter path name.

More Information

Note that if you enter 255 characters in the File Name box in the Save As dialog box, and click OK, you will receive the following error message:

The path you entered, "", is too long. Enter a shorter path.

Also, if you attempt to save a file and the path exceeds 255 characters, you will receive the following error message:

The file could not be accessed. Try one of the following:

- Make sure the specified folder exists. - Make sure the folder that contains the file is not read-only. - Make sure the file name does not contain any of the following characters: < > ? [ ] : | *. - Make sure the file/path name doesn't contain more than 218 characters.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.