Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel2007 Conditional Formatting Slow Performance Issue
Michael, Although my files may not be as extensive as yours, I have not noticed a significant decrease in performance going from 2003 to 2007. I tested an amortization schedule that has 1550 rows of formulae and conditional formatting. Regards: Dave "Michael F" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2007 Conditional Formatting Slow Performance Issue | Excel Worksheet Functions | |||
March Madness and Conditional Formatting (Excel2007) | Excel Discussion (Misc queries) | |||
Performance Measures and Conditional Formatting | Excel Programming | |||
Performance Measures and Conditional Formatting | Excel Worksheet Functions | |||
Performance Measures and Conditional Formatting | Excel Programming |