Hi,
I am trying to run a suite of Excel 2003 spreadsheet macros on Windows 7 with Office 2010; I have not converted them as they are run by several sites globally who may not upgrade to Office 2010 at the same time. Hence they run in compatibility mode which in general is fine.

However, certain macros are veeeery slow and to the user it would look like the app has hung. In debug I have found that the macro takes 10 minutes plus whenever it hits any of the following code:

With Application
     .Calculation = xlAutomatic
     .MaxChange = 0.001
End With

ActiveWorkBook.PrecisionAsDisplayed = False
It goes slow on each of the three 'lines' so it seems that it is actually doing an auto calc each time!

Is there some configuration I can do to prevent this? Setting auto calc to Manual didn't help and anyway I loose things, like data validation, when I save it in Excel 2010.

I tried removing the lines but that caused a runtime subscript out of range error elsewhere!