Article ID: 213913 - View products that this article applies to.
This article was previously published under Q213913
This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel, you may occasionally want to save a document as a text file; for example, to fix corruption in the file.
Although an Excel file is saved as a text file, only the active sheet and the displayed values are saved. All formulas on the active sheet that are not displayed are discarded. This step-by-step article shows you to preserve those formulas that are otherwise discarded.
To display formulas in cells of the active sheet, use one of the following methods.
The only way to preserve the formulas and values that were in individual cells on the original worksheet is to open the file as a tab-delimited file. All other methods force the text file to display its formulas when the Text Import Wizard is finished.