View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Conditional format disaster in 2007


I suspect the Excel team are aware of what most of the speed issues but if
you like you can forward your file, ideally with the minimum to demonstrate
the problem. If there is something specific I'll try and look into whether
or not it has been reported.

My address is lightly disguised in the Reply-to field

Regards,
Peter T

"Michael F" wrote in message
...
I'm having the same issue and can't believe it hasn't been resolved in
either
service pack.

I have a macro that inserts column for each subcontractor who is bidding a
certain trade (ie plumbing, paint, drywall, etc). The data is pulled from
our
bid list workbook and worked like a charm in XL2003. There was quite a
bit
of conditional formatting that would highlight scope gaps and highlight
the
best bid green, second best yellow and third best orange. Now, in XL2007
whenever I have 10 or more companies it takes literally 3-4 seconds
between
key strokes. On bid day, that response time is totally unacceptable. To
resolve I have to clear all conditional formatting from the sheet which is
a
pain b/c I have to manually color cells so I know scope issues I have.
Lately, I've just been going back to using Xl2003.

I'm glad a majority of my large office has not "upgraded" to 2007 since
2003
runs these macros without incident.

Someone at Microsoft has to look into this. If you need some control files
to illustrate the issue please contact me and I'll be happy to send some
files with dummy data to test.