Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL: "Excel Could Not Save All the Data and Formatting" Error Message

XL: "Excel Could Not Save All the Data and Formatting" Error Message

View products that this article applies to.

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

↑ Back to the top

Cause

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

↑ Back to the top

Keywords: KB215783, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 215783
Revision : 5
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 292