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