Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sloooooooooow Chart update on upgrade to 2007
Hi, not really a programer but just write a few macros to speed things up. I
have a set of sharts that I update based on about 35 sets of data. Each set is assigned a range name and the macro just pastes the updated range into the chart, simple. Recently upgraded from Excel 2003 to 2007. The macro work OK but it is now very slow (cf excewl 2003). What use to take say 45 secs in 2003 now takess up to several minutes in 2007. PC is running XP pro, Intel E6400 core 2 duo, 1 Gb ram .. Code is essentially - CURRENT_DATA = Item.Name CHART_NUMBER = CURRENT_DATA & "_Chart_Number" CHART_NAME = "Chart " & Range(CHART_NUMBER).Value ActiveSheet.ChartObjects(CHART_NAME).Activate ActiveChart.PlotArea.Select ActiveChart.SetSourceData Source:=Sheets(CURRENT_DATA).Range(CURRENT_DATA), PlotBy _ :=xlColumns This is really all the macro does, no additional calcs or anything. Any suggestions as to why it runs so slow in 2007 comapred to Excel 2003? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sloooooooooow Chart update on upgrade to 2007
This is a widely reported issue in Excel 2007. I know of no workarounds.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Rick" wrote in message ... Hi, not really a programer but just write a few macros to speed things up. I have a set of sharts that I update based on about 35 sets of data. Each set is assigned a range name and the macro just pastes the updated range into the chart, simple. Recently upgraded from Excel 2003 to 2007. The macro work OK but it is now very slow (cf excewl 2003). What use to take say 45 secs in 2003 now takess up to several minutes in 2007. PC is running XP pro, Intel E6400 core 2 duo, 1 Gb ram . Code is essentially - CURRENT_DATA = Item.Name CHART_NUMBER = CURRENT_DATA & "_Chart_Number" CHART_NAME = "Chart " & Range(CHART_NUMBER).Value ActiveSheet.ChartObjects(CHART_NAME).Activate ActiveChart.PlotArea.Select ActiveChart.SetSourceData Source:=Sheets(CURRENT_DATA).Range(CURRENT_DATA), PlotBy _ :=xlColumns This is really all the macro does, no additional calcs or anything. Any suggestions as to why it runs so slow in 2007 comapred to Excel 2003? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sloooooooooow Chart update on upgrade to 2007
Thanks Jon. Strange as actual calculations seem to run fine, just updating
of graphs is slow. I hope they get a fix! Rick "Jon Peltier" wrote in message ... This is a widely reported issue in Excel 2007. I know of no workarounds. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Rick" wrote in message ... Hi, not really a programer but just write a few macros to speed things up. I have a set of sharts that I update based on about 35 sets of data. Each set is assigned a range name and the macro just pastes the updated range into the chart, simple. Recently upgraded from Excel 2003 to 2007. The macro work OK but it is now very slow (cf excewl 2003). What use to take say 45 secs in 2003 now takess up to several minutes in 2007. PC is running XP pro, Intel E6400 core 2 duo, 1 Gb ram . Code is essentially - CURRENT_DATA = Item.Name CHART_NUMBER = CURRENT_DATA & "_Chart_Number" CHART_NAME = "Chart " & Range(CHART_NUMBER).Value ActiveSheet.ChartObjects(CHART_NAME).Activate ActiveChart.PlotArea.Select ActiveChart.SetSourceData Source:=Sheets(CURRENT_DATA).Range(CURRENT_DATA), PlotBy _ :=xlColumns This is really all the macro does, no additional calcs or anything. Any suggestions as to why it runs so slow in 2007 comapred to Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extremely sloooooooooow subtotalling | Excel Discussion (Misc queries) | |||
Excel 2007 Chart auto update not working | Charts and Charting in Excel | |||
Excel 2007 does not update chart data | Charts and Charting in Excel | |||
Looking for help re chart speed after upgrade to Excel 2007 | Charts and Charting in Excel | |||
upgrade to excel 2003 update broken links error | Links and Linking in Excel |