Exel can`t save file like a text (MS-DOS)

Дарина Обиход 21 Reputation points
2021-10-20T12:52:59.077+00:00

Exel can`t save file like a text (MS-DOS), give me an error, that my file may contain features incompatible with the format "..."

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-10-21T05:44:52.687+00:00

    Hi @Дарина Обиход

    Welcome to Q&A forum ~

    Could you please share with us what version of Office are you using now?
    You could go to File > Account > Product Information to get the version name.

    Generally, Microsoft Excel will claim such information when saving a worksheet as any format other than .xls or .xlsx.
    Under you case, the Text (MS-DOS) format (.*txt) does not support some Excel features, such as formulas, (conditional) formatting, charts and ect.
    So you would receive this message by design.

    If you want to only save data, I suggesy you ignore this message, and click "Yes" like the following image shown to save it as a Text (MS-DOS) file.
    142255-capture41.jpg

    Besides, if you do not want to see this prompt, it's recommended to try to add a registry subkey.
    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
    Value name: DisableSaveAsLossWarningOpenDocumentSpreadsheet
    Value type: DWORD
    Value data: 1
    0 - Display the warning message
    1 - Suppressthe warning message
    (You need to be cautious when modifying the registry. Improper modification may cause some problems.
    It is recommended to back up registry keys before modification, just in case.)


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



0 additional answers

Sort by: Most helpful