LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel2007 Conditional Formatting Slow Performance Issue Michael F Excel Worksheet Functions 1 June 26th 09 05:42 PM
March Madness and Conditional Formatting (Excel2007) Denniso6 Excel Discussion (Misc queries) 0 March 12th 07 03:50 PM
Performance Measures and Conditional Formatting Giacomo Excel Programming 1 February 2nd 07 03:23 AM
Performance Measures and Conditional Formatting Giacomo Excel Worksheet Functions 0 January 31st 07 08:27 PM
Performance Measures and Conditional Formatting Giacomo Excel Programming 0 January 31st 07 08:04 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"