question

25344925 avatar image
0 Votes"
25344925 asked 25344925 commented

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

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

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered 25344925 commented

Hi @25344925

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.





capture41.jpg (16.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@25344925
If you have a chance to be back, please check whether my information is helpful.
Any issues, you could post back.

0 Votes 0 ·

Thanks for your answer! My software version: 14.0.4760.1000 (32-bit).
I could ignore this error, but the file in this extension is necessary for me to work in the program. After consulting with colleagues, I found out that only I have an error in Excel and this file doesn`t open in the working program.

0 Votes 0 ·