I have created a large financial spreadsheet in Excel 2002
for my job. It is very complex with many macro functions
and different cell formatting througout the workbook.

I was nearing completion and and began to consistently
receive a message that says "Too Many Different Cell
Formats". Microsoft's reponse to this is that the
workbook is too complex for Excel to handle and to
simplify it somehow. This workbook does (or will do) what
I need it to do and cannot imagine trimming it down. The
probem had become so bad that the workbook eventually
crashed and all of the formatting data was lost.
Fortunately our server was able to recover the prior days
copy, so I only lost the one days work.

Can anyone provide some advice on this? I getting very
frustrated. Yes this workbook is complex, but I am not an
Excel genius and believe I am only scratching the surface
of its capabilites. I am certain that other users have
created for more complex spreadsheets without experiencing
this problem. PLEASE HELP!