Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Graphs & Macros
I am running XP Pro sp2 and excel 2007.
I have a macro which runs through about 30 graphs and adjusts titles, axis scales, etc depending on the data. Under excel 2003, this would take a few seconds to run, but under excel 2007 it takes about 1 minute. Also, when I try to move around the worksheet with these graphs, the program bogs down and it takes a long time to scroll across the worksheet. I did not have this problem with excel 2003. Any ideas/comments would be greatly appreciated. Thanks Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Graphs & Macros
Idea? Return to XL2003. XL2007 is getting a reputation of both being a lot
slower than 2003 as well as its Graphs being quite buggy. Bob Umlas "Ken" wrote in message ... I am running XP Pro sp2 and excel 2007. I have a macro which runs through about 30 graphs and adjusts titles, axis scales, etc depending on the data. Under excel 2003, this would take a few seconds to run, but under excel 2007 it takes about 1 minute. Also, when I try to move around the worksheet with these graphs, the program bogs down and it takes a long time to scroll across the worksheet. I did not have this problem with excel 2003. Any ideas/comments would be greatly appreciated. Thanks Ken |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Graphs & Macros
MS have acknowledged that charts are a problem in XL2007. Slowing down is a
common complaint. For a hotfix see: http://support.microsoft.com/kb/938538 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ken" wrote in message ... I am running XP Pro sp2 and excel 2007. I have a macro which runs through about 30 graphs and adjusts titles, axis scales, etc depending on the data. Under excel 2003, this would take a few seconds to run, but under excel 2007 it takes about 1 minute. Also, when I try to move around the worksheet with these graphs, the program bogs down and it takes a long time to scroll across the worksheet. I did not have this problem with excel 2003. Any ideas/comments would be greatly appreciated. Thanks Ken |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Graphs & Macros
Ken,
The problems I've experienced with Excel 2007 and charting/graphing are much the same as you've seen and actually with only a 1 minute delay in your case, you're doing better than I am. I have (had - put it all back on 2003) a package I put together for someone that deals with 400,000+ data points split over 50+ graphs. Initially it took 10-11 minutes to finish in 2007 while 2003 would deal with it all in about 1m40s on a slower machine. The Hotfix that came out reduced the time from 10-11 minutes to about 8 minutes for me. One of the first questions I've been asking people who ask me if they 'should' upgrade to Office/Excel 2007 is how much charting/graphing do they do? If the answer is anything other than "none" or "only every once in a while" I tell them to stick with their current version for a while longer. At least wait until SP1 is available and re-evaluate the charting performance at that time. "Ken" wrote: I am running XP Pro sp2 and excel 2007. I have a macro which runs through about 30 graphs and adjusts titles, axis scales, etc depending on the data. Under excel 2003, this would take a few seconds to run, but under excel 2007 it takes about 1 minute. Also, when I try to move around the worksheet with these graphs, the program bogs down and it takes a long time to scroll across the worksheet. I did not have this problem with excel 2003. Any ideas/comments would be greatly appreciated. Thanks Ken |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Graphs & Macros
I should have also mentioned that some VB code I implemented in 2007, like
yours, is slower to run than in 2003. I created a User Defined Function to fill some cells on a sheet with random numbers and it runs many times slower in 2007 than in 2003 - and again, 2003 is running on a single-core processor on a system with 1GB RAM with a lower clock speed than the 2007 machines (1 AMD, 1 Intel) with dual-core CPUs, faster clocks and each with 2GB RAM installed. "Ken" wrote: I am running XP Pro sp2 and excel 2007. I have a macro which runs through about 30 graphs and adjusts titles, axis scales, etc depending on the data. Under excel 2003, this would take a few seconds to run, but under excel 2007 it takes about 1 minute. Also, when I try to move around the worksheet with these graphs, the program bogs down and it takes a long time to scroll across the worksheet. I did not have this problem with excel 2003. Any ideas/comments would be greatly appreciated. Thanks Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and macros | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
paste graphs from Excel 2007 to Word | Charts and Charting in Excel | |||
Excel 2007: More control over graphs wanted | Excel Discussion (Misc queries) | |||
Excel Charts(Graphs) & Macros | Excel Discussion (Misc queries) |