Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel |