I have a workbook with a ton of conditional formatting. It is slowing it down. There are mutiple versions of this file used by multiple people. The versions created in Excel 2010 that have been opened and manipulated by others in Excel 2007 are now extremely slow. I am now trying to just remove all formatting in the files but as soon as I choose remove all from entire sheet, excel crashes and goes to not responding...I have given it 20 minutes and nothing. By the way I have tried to remove from a single cell and got the same result.
Is there a back door to clearing this out of the sheet?
Please let me know
Thank you
Bookmarks