Saving a worksheet

[JONESAROB]

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

[Gordon]

"JONESAROB" <[email protected]> wrote
in message news:[email protected]...
>
> 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

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

[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.