On Oct 21, 1:33*am, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
I need to ask at least one question before continuing: *In your formula,
where it shows IF(Z20, *should that be $Z2 or $Z$2 instead of just plain Z. *
If it is just Z2, then that value is going to become AA2, AB2, AC2, etc. *
Just need to know if that is the intent or not.

My first impulse is to tell you to throw $$ and hardware at it: either
faster machine to get your performance under 2007 back as it was with 2003,
or to come up with a machine you can retrofit with 2003 to use at time
critical moments.


Thanks for your reply. Yes Z2 is used in the formula so adjacent
cells will be AA2, AB2 etc.

My current machine is 2.3Ghz AMD quad-core processor with 4Gb RAM so
it's not as if I'm running the spreadsheet on an old Celeron PC. The
frustrating thing is that Excel 2003 can handle this a lot better but
with the upgrade to Excel 2007 I was hoping to see some 'benefits'.