excel window 365 sending file txt show error 52 how to fix it

Copper Contributor

excel window 365 sending file txt show error 52 how to fix it

1 Reply

@Leonidas_Ubiera 

Error 52 in Excel typically indicates a "Bad file name or number" error. When you encounter this error while sending a file as a .txt (text) file in Excel for the web, it suggests that there may be an issue with the file name or the file itself. Here are some steps to troubleshoot and fix this error:

  1. Check File Name: Ensure that the file name you are specifying for the .txt file is valid and doesn't contain any special characters or reserved characters like \ / : * ? " < > |.
  2. File Format: Confirm that the content you are trying to save as a .txt file is indeed in a format that Excel for the web can export as text. Make sure there are no unsupported features or formatting in your Excel workbook that might be causing the error.
  3. Save As .txt: Follow these steps to save your Excel workbook as a .txt file:
  • Click on "File" in the Excel for the web menu.
  • Choose "Download" and then select "Plain Text (.txt)" from the available formats.
    • Provide a valid file name and location for the .txt file.
  1. Check for Special Characters: If your worksheet contains special characters or symbols that might not be supported in a plain text file, consider removing or replacing them.
  2. Update or Use Different Browser: Sometimes, browser-related issues can affect how web applications like Excel for the web function. Ensure that your browser is up-to-date, or try using a different browser to see if the issue persists.
  3. Excel Updates: Make sure that you have the latest updates for Excel for the web. Microsoft may have released updates or patches that address compatibility issues.
  4. Browser Add-ons/Extensions: Disable any browser add-ons or extensions that might interfere with the functionality of Excel for the web.
  5. Clear Browser Cache: Clear your browser's cache and cookies, as outdated data can sometimes cause unexpected errors.
  6. Try a Different Method: If saving as .txt in Excel for the web continues to give you problems, you can consider downloading the file as an Excel workbook (.xlsx) and then using desktop Excel to save it as a .txt file. This may bypass any limitations in Excel for the web.

Remember to save your work and any changes you make before attempting any of these troubleshooting steps. If this is not what you are looking for, please provide detailed information such as a step by step description of the problem, Excel version, operating system, storage medium, etc. A file or photos would also be beneficial.The text and steps were edited with the help of AI.

 

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.