Re: Degradation of performance : upgrading from Excel 2000 to Excel 20

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

Well, you have various responses; make of them what you will.

It would seem though, that upgrading for functionality may be worthwhile,
but not for performance.

NickHK

"ecanet" <ecanet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46649B7E-C9ED-4DC4-9BCF-469C366E9831@xxxxxxxxxxxxxxxx
Hi all,

I know everyone is looking for latest version, but I work as a developer
and
my customer use Excel 2000. He asked me to evaluate the cost of an upgrade
to
Excel 2003, so here I am.

My program must fill 5000*255 cells.
I use the VBA method "Resize" to select all the range, then "Value" and
set
them with an array containing all the datas.
AFAIK, this is the most effective way to do this.


The problem I have is about the performances :
this code works both on Excel 2000 and on Excel 2003 but on the same
computer respectively need 3 sec and 9 sec.
This difference is not acceptable by my customer.


Could anyone tell me if this lack of perf is a known issue when upgrading
and if there is a workaround ?
I see on the net that this is a computer problem, but I'm afraid that they
wouldn't change their hardware for more competitive ones.....


Thanks for giving me any pointers and have a nice day !


Manu, hope I made myself clear enough, I'm not a good english speaker !


.

Relevant Pages

  • Re: issues with excel services
    ... RTM or both beta 2 TR. ... upgrading we had defined several dashboards using excel web services ... But the issue is that when I try now to publish an excel 2007 file ... I can upload any other file without a problem, word, excel 2003, text ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Excel 2007 vs. Excel 2003
    ... Some of the charting functionality of Excel ... Before upgrading, carry out your due diligence by scanning these groups, ... continued work to fix things when my clients upgrade. ...
    (microsoft.public.excel.programming)
  • Re: Cannot install excel
    ... If you did a complete install of WinXP Pro, ... (Upgrading to WinXP Pro SP2 didn't play any role in this.) ... If you upgraded from a previous version of windows (not by formatting the ... So depending on what you did, excel could still be there on your harddrive. ...
    (microsoft.public.excel.setup)
  • Re: export to excel
    ... have several reports in the similar way, but I haven't seen any difference ... upgrading to Office 2003. ... "Andre" wrote in message ... > the pages exports the html to Excel. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Leopard document size set at 4 x 4 inches default
    ... After installing Leopard and upgrading to Excel / Office ... Resetting the page break's doesn't solve the problem, ...
    (microsoft.public.mac.office.excel)