Saving a worksheet
 

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


--
JONESAROB
------------------------------------------------------------------------
JONESAROB's Profile: http://www.excelforum.com/member.php...o&userid=37063
View this thread: http://www.excelforum.com/showthread...hreadid=567816

Saving a worksheet
 

"JONESAROB" wrote
in message ...

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

Saving a worksheet
 

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.


--
JONESAROB
------------------------------------------------------------------------
JONESAROB's Profile: http://www.excelforum.com/member.php...o&userid=37063
View this thread: http://www.excelforum.com/showthread...hreadid=567816