View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Picman Picman is offline
external usenet poster
 
Posts: 70
Default Conditional Format limitations

When I try to save my file (Excel 2003) after making some formatting changes
I receive an error message that states:

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

To return to your workbook without saving click Cancel.
If you want to continue saving changes without repairing the problem, click
OK.€

What it doesnt want to save is conditional formatting beyond row 6158. The
whole workbook is only about 12mb, it contains six sheets five of which are
tables of data, and the sixth is a summary page that retrieves data from the
others. The sumary page is approx 8400 rows by 20 columns with every seventh
row containing a conditional format in 14 of the cells across. The
conditional format is simple as well, if the number is less than 0 format the
value to be bold and red, and thats it. I've tried to remove all of the
other formatting (bold, borders etc.) but nothing seems to work.

I don't understand why Excel is having any difficulties handling this. Got
any ideas? Please.