Sửa lỗi excel cannot open the special file năm 2024
In the 'Excel Options' window, under the Save workbooks section, click on the Save files in this file format: drop-down. Next, select a file format (i.e., the one supported by your Excel version).
Check if you can open your Excel file. If not, try the next solution. Solution 2: Edit the excel file permissions Follow these steps to change the file permissions and see if it fixes the problem:
Now try to open the Excel file. If you are still getting the Excel file cannot open error, you can refer to the following thread and article: https://social.technet.microsoft.com/Forums/office/en-US/63020ccc-51d7-46d9-b956-121c0e6efcc8/excel-... https://www.stellarinfo.com/article/excel-cannot-open-the-file-because-the-extension-is-not-valid.ph... 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, ' Error message 4 Error message 5 In Microsoft Office Excel 2007, you may receive the following error message: ' 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. CauseThis 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:
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 TryMake sure that the path to the file contains fewer than 219 characters. To do this, use one of the following methods:
More InformationNote 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, " 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. |