Thank you Dave,
Prior to your response, I had done some other checking and made some changes
imrpoved (though not fully alleciated) the problems.
For reference (and in aswer to your question) the problems I am expereincing
are entirely new. I was running Win98SE & Office 2000. I have done a lot of
VBA performance optimization (aka good coding practices) and general
spreadsheet design to maximise performance. All was running real sweet untill
WinXP & Office 2003 was installed.
Following a day or so of moding my VBA code and Chart Layouts in response to
both new features and "other changes" in 2003 I went into full operational
testing - and the proverbial hit the fan. "First level" investigations
provided no clues and that was when I posted my querie (and am very thankfull
for your reply).
I went through (in some detail) the suggestions provided by the first link
in your response. Many of these I was already aware of (as I have a done a
lot of VBA coding for my Excel projects). However there were quite a few I
was not aware of and have implemented the recommended changes. Mostly these
had to do with ripping back out some of the new features of Office (installed
but not turned on). I have also Re "Saved As" all files to ensure no
lingering "Pre 2003" data.
Over the next week I will revisit some of other "less critcal items"
idenftified in your response, while doing more perfromace testing. Will keep
you posted if you wish...
Thank you again,
Spinner
"David McRitchie" wrote:
Perhaps you can find something in
http://www.mvps.org/dmcritchie/excel/slowresp.htm
there is nothing there specific to Excel 2003, though some of
the referenced links might relate more to 2003.
Some things to also consider. did the problem start with Excel 2003
does it get worse and worse once on 2003.
Quick things to try: clear the Internet Explorer cashe,
make sure journalling is not turned on that is if you have
Outlook installed. Make sure you are not saving files
for multiple version of Excel this would double the file size.-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Spinner" wrote in message ...
I upgraded from Office 2000 to 2003. I have [fairly] large workbooks (7-10
MB) with many embedded charts and controls (i.e. lots of shapes).
Following the upgrade, everyting to significantly slower. Of particular
concern is the rate of simply swicthing between worksheets in a workbook.
Previoulsy, I could toggle back and forth between sheets to compare charts.
The transission rate is now so slow, this is no longer a practicle option.
Any clues on how/if Excel 2003 can be tuned to run faster?