Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO IMPROVE PERFORMANCE FOR VB
I created vs for excel 11.81 on an NT box then loaded it onto a new version
of excel on Vista. The execution performance is an order of magnatude slower in Vista and the new version of excel 12.06. The code is simple formating and reading from one sheet and writing to cells in another sheet in the same workbook. Both systems are dual core with the same memory. Vist has faster processors. Any configurations or tricks on using the new excel on vista? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO IMPROVE PERFORMANCE FOR VB
Excel 12 is quite a lot slower than previous versions with VB, but maybe the
SP1 update due out next week will improve things. Standard speedup tricks - you need to - read and write many cells at once using Variant=Range and Range=variant - uninstall Google Desktop Office COM addin. - switch off screenupdating and automatic calculation To see the performance implications/example download the variantbenchmark from http://www.decisionModels.com/downloads.htm Charles _________________________________________ FastExcel 2.3 Name Manager 4.0 http://www.DecisionModels.com "dhomer" wrote in message ... I created vs for excel 11.81 on an NT box then loaded it onto a new version of excel on Vista. The execution performance is an order of magnatude slower in Vista and the new version of excel 12.06. The code is simple formating and reading from one sheet and writing to cells in another sheet in the same workbook. Both systems are dual core with the same memory. Vist has faster processors. Any configurations or tricks on using the new excel on vista? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improve the performance of Excel 2007. | Excel Worksheet Functions | |||
Help Optimizing a Sheet to improve performance | Excel Worksheet Functions | |||
Trying to improve the performance of my code | Excel Programming | |||
PageBreak problem. How to improve performance? | Excel Programming | |||
Advanced Filters - improve performance ? | Excel Programming |