Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 and 2007
Hello, a bit of a strange question.
I have a vba program, which reads data from one sheet and writes to another sheet. Performance tests have shown, 7 - 11 minutes in Excel 2003 2 -3 minutes in Excel 2007 Same data, same code. Did 2007 have huge performance gains? Is there anything i can set in 2003 to get additional performance? Such as shutting off calculation? Printer settings? Something else? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 and 2007
Most people report the reverse -- Excel 2007 is slower than 2003. Your
performance gains are probably due the new multithreaded calculation engine. This allows "simulatenous" (as far as that goes regarding threads of execution) calcuation of two or more cells whose values do not depend on the other. This can yield performance gains over the strict and orderly cell by cell calculation in 2003. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 14 May 2009 11:22:15 -0500, "greg" wrote: Hello, a bit of a strange question. I have a vba program, which reads data from one sheet and writes to another sheet. Performance tests have shown, 7 - 11 minutes in Excel 2003 2 -3 minutes in Excel 2007 Same data, same code. Did 2007 have huge performance gains? Is there anything i can set in 2003 to get additional performance? Such as shutting off calculation? Printer settings? Something else? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 and 2007
thanks,
Any tricks on excel 2003? excel settings i can look at? or do you think that will not help? "Chip Pearson" wrote in message ... Most people report the reverse -- Excel 2007 is slower than 2003. Your performance gains are probably due the new multithreaded calculation engine. This allows "simulatenous" (as far as that goes regarding threads of execution) calcuation of two or more cells whose values do not depend on the other. This can yield performance gains over the strict and orderly cell by cell calculation in 2003. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 14 May 2009 11:22:15 -0500, "greg" wrote: Hello, a bit of a strange question. I have a vba program, which reads data from one sheet and writes to another sheet. Performance tests have shown, 7 - 11 minutes in Excel 2003 2 -3 minutes in Excel 2007 Same data, same code. Did 2007 have huge performance gains? Is there anything i can set in 2003 to get additional performance? Such as shutting off calculation? Printer settings? Something else? thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 and 2007
Charles Williams has quite a bit of info about Excel calculations and
how to optimize them on his site at http://www.decisionmodels.com/index.htm Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 14 May 2009 11:53:06 -0500, "greg" wrote: thanks, Any tricks on excel 2003? excel settings i can look at? or do you think that will not help? "Chip Pearson" wrote in message .. . Most people report the reverse -- Excel 2007 is slower than 2003. Your performance gains are probably due the new multithreaded calculation engine. This allows "simulatenous" (as far as that goes regarding threads of execution) calcuation of two or more cells whose values do not depend on the other. This can yield performance gains over the strict and orderly cell by cell calculation in 2003. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 14 May 2009 11:22:15 -0500, "greg" wrote: Hello, a bit of a strange question. I have a vba program, which reads data from one sheet and writes to another sheet. Performance tests have shown, 7 - 11 minutes in Excel 2003 2 -3 minutes in Excel 2007 Same data, same code. Did 2007 have huge performance gains? Is there anything i can set in 2003 to get additional performance? Such as shutting off calculation? Printer settings? Something else? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens two windows (2007 & 2003 format): I want only 2003. | Excel Discussion (Misc queries) | |||
Saving from 2007 to 2003 - 2003 won't open the file | Excel Discussion (Misc queries) | |||
2003-2007 xlsm-2003 loses worksheet commandbutton functionality | Excel Programming | |||
2003--2007 recognize if i'm in 2007 or 2003 via code. | Excel Programming | |||
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming |