Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an
..xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
ps: I timed how long it takes workbook to save: 25 seconds.
"WCM" wrote: I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an .xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
I know that things are slower on 2007 than 2003, but there may be some things
you can do to speed up execution. I usually add at least this to do that Application.Calculation = XLCalculationManual Application.ScreenUpdating = False Application.Enableevents = False (above before code) (below after code) Application.Calculation = XLCalculationAutomatic Application.ScreenUpdating = True Application.Enableevents = True HTH (some) Barb Reinhardt "WCM" wrote: I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an .xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
WCM wrote:
ps: I timed how long it takes workbook to save: 25 seconds. "WCM" wrote: I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an .xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill Are charts and graphs involved? That is the only situation I have found where the performance of XL2007 is more than an order of magnitude slower and borderline unstable because of race conditions. The sorts of things the go wrong are axes get referneced by VBA before they have been drawn. You can fix it with judicious use of delays and that appears to have been the bodge applied to the main code too :( Some of my calibration spreadsheets with many graphs that were a couple of seconds or less on XL2003 now have to display an estimated wait time in minutes to stop the users from aborting it! Regards, Martin Brown |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
For what it is worth...
MS is now bragging? http://blogs.msdn.com/excel/ that xl2010 (preview version) handles charts much faster then xl2007. It will only require ~twice as much time as XL2003. -- Jim Cone Portland, Oregon USA |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
Hi Martin,
Thank you for your response. No, I do not have any charts for other graphics - only several simple macros that do easy updates on 500 rows of data. Same situation in Excel2003 would take 1-2 seconds to save. "Martin Brown" wrote: WCM wrote: ps: I timed how long it takes workbook to save: 25 seconds. "WCM" wrote: I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an .xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill Are charts and graphs involved? That is the only situation I have found where the performance of XL2007 is more than an order of magnitude slower and borderline unstable because of race conditions. The sorts of things the go wrong are axes get referneced by VBA before they have been drawn. You can fix it with judicious use of delays and that appears to have been the bodge applied to the main code too :( Some of my calibration spreadsheets with many graphs that were a couple of seconds or less on XL2003 now have to display an estimated wait time in minutes to stop the users from aborting it! Regards, Martin Brown |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
Hi Barb,
Thanks for your suggestion. Problem isn't that the macros run slow - they actually run fine - it is the development process itself. I have to wait a long time for any macro changes I make to 'save' and saving workbook takes 25 seconds. A bit frustrating since I'm used to "lightening speed" in 2003. I am actually getting used to 'multi-tasking' while waiting for workbook to save ... work in sql server or something to use up the time, then come back to workbook ... "Barb Reinhardt" wrote: I know that things are slower on 2007 than 2003, but there may be some things you can do to speed up execution. I usually add at least this to do that Application.Calculation = XLCalculationManual Application.ScreenUpdating = False Application.Enableevents = False (above before code) (below after code) Application.Calculation = XLCalculationAutomatic Application.ScreenUpdating = True Application.Enableevents = True HTH (some) Barb Reinhardt "WCM" wrote: I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an .xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
Hi Jim,
Not too encouraging ... don't want to revert to 2003 as I'm now used to the many design changes in 2007, but this is first time I've had to run VBA in 2007 - and like I say, run speed is okay it is the development that is slow. If I find a solution, I will come back here to post. "Jim Cone" wrote: For what it is worth... MS is now bragging? http://blogs.msdn.com/excel/ that xl2010 (preview version) handles charts much faster then xl2007. It will only require ~twice as much time as XL2003. -- Jim Cone Portland, Oregon USA |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
As I said, I'll be happy to take a look.
-- Don Guillett Microsoft MVP Excel SalesAid Software "WCM" wrote in message ... Hi Jim, Not too encouraging ... don't want to revert to 2003 as I'm now used to the many design changes in 2007, but this is first time I've had to run VBA in 2007 - and like I say, run speed is okay it is the development that is slow. If I find a solution, I will come back here to post. "Jim Cone" wrote: For what it is worth... MS is now bragging? http://blogs.msdn.com/excel/ that xl2010 (preview version) handles charts much faster then xl2007. It will only require ~twice as much time as XL2003. -- Jim Cone Portland, Oregon USA |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
Don,
I inadvertently skipped over your response. Suggestion is a good one as I have made that mistake before. I am reviewing workbook and will get back to you. I this doesn't solve problem, I will send you file for analysis on your end. Thanks for your response ... Bill "Don Guillett" wrote: Do you have formulas using entire columns? If desired, send your file to my address below along with this msg and a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "WCM" wrote in message ... Hi Martin, Thank you for your response. No, I do not have any charts for other graphics - only several simple macros that do easy updates on 500 rows of data. Same situation in Excel2003 would take 1-2 seconds to save. "Martin Brown" wrote: WCM wrote: ps: I timed how long it takes workbook to save: 25 seconds. "WCM" wrote: I am running Excel 2007 on Vista (2GB Ram / 3GHz CPU). I am working on an .xlsm file with 6 short macros and 500 4-column rows of data. Switching back and forth between the Excel sheet and the VBA code window takes way too long (about 10 seconds) and saving the workbook also takes approx 10 seconds. If I use Excel 2000 for the same work, it is extremely fast - not enough delay to notice. Nothing wrong with my machine. Anyone know why working on an .xlsm workbook would on Vista would be so slow? Am I missing something? Thanks for your help ... Bill Are charts and graphs involved? That is the only situation I have found where the performance of XL2007 is more than an order of magnitude slower and borderline unstable because of race conditions. The sorts of things the go wrong are axes get referneced by VBA before they have been drawn. You can fix it with judicious use of delays and that appears to have been the bodge applied to the main code too :( Some of my calibration spreadsheets with many graphs that were a couple of seconds or less on XL2003 now have to display an estimated wait time in minutes to stop the users from aborting it! Regards, Martin Brown |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
Many links that went nowhere and defined names with non existent references
may be the problem. -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... As I said, I'll be happy to take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "WCM" wrote in message ... Hi Jim, Not too encouraging ... don't want to revert to 2003 as I'm now used to the many design changes in 2007, but this is first time I've had to run VBA in 2007 - and like I say, run speed is okay it is the development that is slow. If I find a solution, I will come back here to post. "Jim Cone" wrote: For what it is worth... MS is now bragging? http://blogs.msdn.com/excel/ that xl2010 (preview version) handles charts much faster then xl2007. It will only require ~twice as much time as XL2003. -- Jim Cone Portland, Oregon USA |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel .xlsm / Vista / Speed Problem
Don,
That was it!! Thank you so much for your review. There were many connections to other files that were totally unnecessary. After removing them per your suggestion (Data Connections), the workbook saves in a flash and opens just as fast. Thank you again ... Bill "Don Guillett" wrote: Many links that went nowhere and defined names with non existent references may be the problem. -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... As I said, I'll be happy to take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "WCM" wrote in message ... Hi Jim, Not too encouraging ... don't want to revert to 2003 as I'm now used to the many design changes in 2007, but this is first time I've had to run VBA in 2007 - and like I say, run speed is okay it is the development that is slow. If I find a solution, I will come back here to post. "Jim Cone" wrote: For what it is worth... MS is now bragging? http://blogs.msdn.com/excel/ that xl2010 (preview version) handles charts much faster then xl2007. It will only require ~twice as much time as XL2003. -- Jim Cone Portland, Oregon USA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007/Vista - PastePicture Problem | Excel Programming | |||
xls to xlsm conversion problem | Excel Discussion (Misc queries) | |||
Slow speed opening XLSM compared to XLS | Excel Discussion (Misc queries) | |||
Unhide Problem in Vista & Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Speed Problem | Excel Discussion (Misc queries) |