XL2000: "Excel could not save all the data and formatting" Error

ID: Q215783

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

In Microsoft Excel, if you format a large selection with conditional formatting and then save the file, you may receive the following error message:

Excel could not save all the data and formatting you recently added to filename.xls

CAUSE

This error message appears when you have applied conditional formatting to more than 2,050 rows. This is a limitation in the way Excel saves information about your file.

Additional query words: XL2000

Keywords : kberrmsg xlformat
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb