Saving a worksheet

J

JONESAROB

Hi
When I save, a warning appears that data and formatting recently adde
can not be saved. How can this be overcome ?

Thanks in advanc
 
G

Gordon

JONESAROB said:
Hi
When I save, a warning appears that data and formatting recently added
can not be saved. How can this be overcome ?

Thanks in advance
Click to expand...

Are you opening files in Read-Only mode? (It'll tell you on the top of the
window.......)
 
J

JONESAROB

I think I have found out why, it is because you can not have more than
2500 conditional formatting per work sheet. I had about 6500, so
therefore I have broken it down into three sheets, and now it saves !

Thank you for your reply, if you know different give us a shout.
 
Top