View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Conditional Formatting Error

Based on your report it certainly looks as if the same problem exists in
Excel 2003 even though there is no article for it specifically. If I knew
how to reproduce the problem I'd see if Excel 2007 fixed it. Applying the
same format to rows 1:2051+ doesn't seem to reproduce it.

This is the article Debbie found:

http://support.microsoft.com/kb/215783/en-us

--
Jim
"Debbie" wrote in message
...
|I have a large file with a lot of conditional formatting. Up until today
it
| worked fine. Today I have made some changes to the formatting, which
works,
| but when I go to save the file, I am getting an error message that says
| Excel could not save all the data and formatting you recently added to
(file
| name).xls
|
| All I could find on Microsoft help and support was that in 2002 and 2000
you
| are limited to 2050 rows. I have Excel 2003.
|
| Can anyone help with this?