LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy conditional format without using format painter MsConfused Excel Worksheet Functions 2 May 4th 09 07:16 AM
New Conditional Format Overriding Previous Conditional Format Rene Excel Discussion (Misc queries) 3 February 27th 08 06:08 PM
How to create a conditional format that changes the number format tmbo Excel Discussion (Misc queries) 1 August 23rd 06 06:20 AM
Conditional Format - Format Transfer To Chart ju1eshart Excel Discussion (Misc queries) 0 June 1st 06 02:46 PM
copy conditional format to regular format GDC Setting up and Configuration of Excel 3 May 4th 05 09:35 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"