Forum Discussion
Excel file error
thank you a lot for providing wide methods as they are usual methods and common, but I tried all these methods previously as I have to share my problem to your community.
Please help me with a special solution to my file, because all previous methods didn't give me anything.
My file has a lot of comments, but they appear, but cell with text values only don't appear, give me #VALUE!
Additional possible sources of error:
From repeatedly saving an Excel file in different formats or from converting it between formats, such as .xlsx (Excel Workbook) to .xls (Excel 97-2003 Workbook) can arise the problem too.
As example, the file size limit for .xls is 65,536 rows by 256 columns, while .xlsx supports up to 1,048,576 rows by 16,384 columns. If the data exceeds these limits, it can result in data loss.
Excel often creates temporary files while you're working. These files might still be present on your system and can sometimes be used to recover lost data.
- Look for files with the extension .tmp in the same directory as your original file or in the system's temporary folder.
- Rename the temporary file extension from .tmp to .xls or .xlsx.
- Attempt to open the renamed file in Excel.
Maybe you could insert the file (without sensitive data) to better evaluate the recovery options.
This is where I've reached the end of my Latin comprehension.
Hope this will help you.
NikolinoDE
Is there any solution for my excel file, please???1- The data in my file didn't reach 65,536 rows or 256 columns.
2-There isn't any files with extension .tmp in the file location and drive.
