Speed Issue

[Ron Rosenfeld]

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 worksheet 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

 

[Bernard Liengme]

Interesting. I will look for a macro to remove all CFs and see if it speeds
up a Solver worksheet that is slower in XL2007 than in XL2003 where it was
first developed
best wishes

 

[Bob Flanagan]

As info, I found that Excel 2007 slows down significantly, like 25X, if
there are lots of equations in Excel and one runs a macro. And, the
equations do not have to be related to the cells being modified. I have
reported it to Microsoft many months ago. Hopefully they will get around to
fixing. The only cure so far is to close unrelated workbooks, and if
possible split workbooks into many so more equations can be removed from
Excel.

Bob

 

[Charles Williams]

anything involving VBA read or write is a lot slower in 2007.
see: http://www.decisionmodels.com/VersionCompare.htm

But this does NOT account for the condtional formatting problem

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Ron Rosenfeld]

Interesting. I will look for a macro to remove all CFs and see if it speeds
up a Solver worksheet that is slower in XL2007 than in XL2003 where it was
first developed
best wishes

It'd sure be interesting if you or any others have a similar problem and
resolution.
--ron

 

[Ron Rosenfeld]

anything involving VBA read or write is a lot slower in 2007.
see: http://www.decisionmodels.com/VersionCompare.htm

But this does NOT account for the condtional formatting problem

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

Unfortunately, the error file did not give examples of the CF that it thought
was a problem. And I have no way to reproduce the CF formulas at this time.
--ron