ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 Performance/Status Bar Quest (https://www.excelbanter.com/excel-programming/363549-excel-2003-performance-status-bar-quest.html)

Grumpy Aero Guy[_3_]

Excel 2003 Performance/Status Bar Quest
 
I have an excel file that performs significant iterations and repetitions
(extensive VB code) to arrive at various solutions...

I have a few questions:

1) Is it just me, or is excel 2003 SP2 MUCH slower than Excel 2000 from a VB
standpoint?

Work Computer: 512Mb Ram, slower processor than my home computer, Excel 2000

Home Computer, 1G RAM, faster processor than work computer, Excel 2003 SP2

Work Computer gets thru the calculations MUCH faster.... ??????????

Is this expected? Is 2003 more "bloated" than Excel 2000?

2) On Excel 2003, I DO NOT get the statusbar indicating "Calculating Cells
XX%" while it's crunching.

On Excel 2000, I DO see the statusbar.

In my case, the status bar message is very useful.... Any way to invoke it
in 2003? I searched KB and didn't find any articles on the statusbar that
addressed this issue.


--
Grumpy Aero Guy





Tom Ogilvy

Excel 2003 Performance/Status Bar Quest
 
http://support.microsoft.com/kb/825012/en-us

--
Regards,
Tom Ogilvy


"Grumpy Aero Guy" wrote:

I have an excel file that performs significant iterations and repetitions
(extensive VB code) to arrive at various solutions...

I have a few questions:

1) Is it just me, or is excel 2003 SP2 MUCH slower than Excel 2000 from a VB
standpoint?

Work Computer: 512Mb Ram, slower processor than my home computer, Excel 2000

Home Computer, 1G RAM, faster processor than work computer, Excel 2003 SP2

Work Computer gets thru the calculations MUCH faster.... ??????????

Is this expected? Is 2003 more "bloated" than Excel 2000?

2) On Excel 2003, I DO NOT get the statusbar indicating "Calculating Cells
XX%" while it's crunching.

On Excel 2000, I DO see the statusbar.

In my case, the status bar message is very useful.... Any way to invoke it
in 2003? I searched KB and didn't find any articles on the statusbar that
addressed this issue.


--
Grumpy Aero Guy







All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com