Re: Speed Issue

Tech-Archive recommends: Fix windows errors by optimizing your registry

Interesting. I will look for a macro to remove all CFs and see if it speeds
up a Solver work*** that is slower in XL2007 than in XL2003 where it was
first developed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ron Rosenfeld" <ronrosenfeld@xxxxxxxxxx> wrote in message
news:n0qbo4lojtiln5askq8gup984mvnoue8mp@xxxxxxxxxx
Interesting issue and apparent resolution. I pass this along as it may be
a
cause of other's speed issues.

I have a very basic Sudoko solver program, that only does what I might do
manually. One day, quite a while after switching from XL2003-2007, it
began to
run slowly. Slowly as in a macro that would run in less than 1/2 second
was
taking 10-12 seconds to complete.

Screen updating was off. I then looked closely at the macro, and made a
few
changes with no significant affect. I also changed the file type from
xlsm to
xlsb -- also with no effect.

Yesterday the work*** crashed and, when recovered, the "repair" message
indicated that "One or more invalid conditional formats were removed from
the
workbook"

After that speed was back to normal.

I don't recall what the CF formulas were, but a set of them were gone. I
added
back in CF that did the same thing, and everything continues to work
properly.
--ron


.

Quantcast