View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Michael F Michael F is offline
external usenet poster
 
Posts: 3
Default Excel2007 Conditional Formatting Slow Performance Issue


Has anyone else notice a drastic performance issue with Excel 2007's
conditional formatting?

I have a workbook and code that I wrote for XL2003 which has worked great
for a year, no hiccups or performance issues. However when I open the same
workbook and run the same macro in XL2007 it will either take an extended
amount of time to run or crash Excel 2007 all together. Even if the macro
completes when I move around the worksheet it takes 2,3, sometimes 5 seconds
to move between cells.

To make it bearable I have to remove all the conditional formatting from the
sheet, which isn't a permanent fix as the conditional formatting actually has
a purpose to highlight gaps between my data.

I've searched Microsoft but can't find any KB articles and I'm not paying
$300 to email my question to them. I'm hoping (wishful thinking, I know) that
someone at Microsoft may look at message board threads with a lot of activity
so if you're experiencing conditional formatting performance issues, please
reply to this thread just to let people know you have the problem.

Thanks!