Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I the Only One Having Excel 2007 Performance Problems
I have a Centrino Duo T2300 with 1 Gig of Ram and loaded the demo version of
Offict 2007 Professional. I have a 15 Meg spreadsheet created in Excel 2003 which I loaded and saved it in Excel 2007. It has a number of graph tabs. When I press a graph tab it takes almost 5 seconds to switch between tabs. This was almost instantaneous on 2003. It this the expected performance. In addition the the memory size increases significantly with each graph tab and is currently sitting at over 400 Meg. Spreadsheed is ~ 8300 rows of data (345 days of hourly data). The recalculation is turned off and I need to do a simple X-Y plot of 5 variable versus time. To get graphs by month I have copied the same chart and change the X-Scale min/max values to show 1 month of data per Tab. the result is each graph displays ~750 data points of the 8300 defined in the graph range. In Excel 2003, the ability to switch tabs is "instantaneous" in Excel 2007 it takes ~5 seconds the first time and is shorter if it is reselected. Each tab that is selected used a significant chunch of memory. This makes Excel 2007 unusable to me and I have removed the Office 2007 Professional Trial version and have gone back to 2003 where I'll have to stay is this is Excel 2007's performance. For a spreadsheet that supports 1,000,000 rows, graphing of this data set should be a breeze not a significant slowdown from 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I the Only One Having Excel 2007 Performance Problems
I run XL 2007 on an AMD dual core with 2 gb of RAM and have noticed any
performance degradation. Do you have multi-threaded calculation enabled? Go to the office icon in the upper left hand corner, select Excel Options, then look for the calculation section, in which you can specify how many processors XL uses. -- Brevity is the soul of wit. "Concerned" wrote: I have a Centrino Duo T2300 with 1 Gig of Ram and loaded the demo version of Offict 2007 Professional. I have a 15 Meg spreadsheet created in Excel 2003 which I loaded and saved it in Excel 2007. It has a number of graph tabs. When I press a graph tab it takes almost 5 seconds to switch between tabs. This was almost instantaneous on 2003. It this the expected performance. In addition the the memory size increases significantly with each graph tab and is currently sitting at over 400 Meg. Spreadsheed is ~ 8300 rows of data (345 days of hourly data). The recalculation is turned off and I need to do a simple X-Y plot of 5 variable versus time. To get graphs by month I have copied the same chart and change the X-Scale min/max values to show 1 month of data per Tab. the result is each graph displays ~750 data points of the 8300 defined in the graph range. In Excel 2003, the ability to switch tabs is "instantaneous" in Excel 2007 it takes ~5 seconds the first time and is shorter if it is reselected. Each tab that is selected used a significant chunch of memory. This makes Excel 2007 unusable to me and I have removed the Office 2007 Professional Trial version and have gone back to 2003 where I'll have to stay is this is Excel 2007's performance. For a spreadsheet that supports 1,000,000 rows, graphing of this data set should be a breeze not a significant slowdown from 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I the Only One Having Excel 2007 Performance Problems
You've posted this already, and some people have agreed that there are
performance issues in some of Excel's operations. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Concerned" wrote in message ... I have a Centrino Duo T2300 with 1 Gig of Ram and loaded the demo version of Offict 2007 Professional. I have a 15 Meg spreadsheet created in Excel 2003 which I loaded and saved it in Excel 2007. It has a number of graph tabs. When I press a graph tab it takes almost 5 seconds to switch between tabs. This was almost instantaneous on 2003. It this the expected performance. In addition the the memory size increases significantly with each graph tab and is currently sitting at over 400 Meg. Spreadsheed is ~ 8300 rows of data (345 days of hourly data). The recalculation is turned off and I need to do a simple X-Y plot of 5 variable versus time. To get graphs by month I have copied the same chart and change the X-Scale min/max values to show 1 month of data per Tab. the result is each graph displays ~750 data points of the 8300 defined in the graph range. In Excel 2003, the ability to switch tabs is "instantaneous" in Excel 2007 it takes ~5 seconds the first time and is shorter if it is reselected. Each tab that is selected used a significant chunch of memory. This makes Excel 2007 unusable to me and I have removed the Office 2007 Professional Trial version and have gone back to 2003 where I'll have to stay is this is Excel 2007's performance. For a spreadsheet that supports 1,000,000 rows, graphing of this data set should be a breeze not a significant slowdown from 2003. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I the Only One Having Excel 2007 Performance Problems
Jon - The items they suggested such as turning re-calculation off I did and
the Graphics Re-draw don't seem to be the problem. Maybe I am the only one doing fairly large data manipulation in Excel but I though a spreadsheet that supports a million rows should be able to handle large data sets. I was really looking to get some feedback from users of larger data sets on their performance observations. Thanks "Jon Peltier" wrote: You've posted this already, and some people have agreed that there are performance issues in some of Excel's operations. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Concerned" wrote in message ... I have a Centrino Duo T2300 with 1 Gig of Ram and loaded the demo version of Offict 2007 Professional. I have a 15 Meg spreadsheet created in Excel 2003 which I loaded and saved it in Excel 2007. It has a number of graph tabs. When I press a graph tab it takes almost 5 seconds to switch between tabs. This was almost instantaneous on 2003. It this the expected performance. In addition the the memory size increases significantly with each graph tab and is currently sitting at over 400 Meg. Spreadsheed is ~ 8300 rows of data (345 days of hourly data). The recalculation is turned off and I need to do a simple X-Y plot of 5 variable versus time. To get graphs by month I have copied the same chart and change the X-Scale min/max values to show 1 month of data per Tab. the result is each graph displays ~750 data points of the 8300 defined in the graph range. In Excel 2003, the ability to switch tabs is "instantaneous" in Excel 2007 it takes ~5 seconds the first time and is shorter if it is reselected. Each tab that is selected used a significant chunch of memory. This makes Excel 2007 unusable to me and I have removed the Office 2007 Professional Trial version and have gone back to 2003 where I'll have to stay is this is Excel 2007's performance. For a spreadsheet that supports 1,000,000 rows, graphing of this data set should be a breeze not a significant slowdown from 2003. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I the Only One Having Excel 2007 Performance Problems
Have you read Charles Williams' article? He's an expert on Excel
performance: http://msdn2.microsoft.com/en-us/library/aa730921.aspx - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Concerned" wrote in message ... Jon - The items they suggested such as turning re-calculation off I did and the Graphics Re-draw don't seem to be the problem. Maybe I am the only one doing fairly large data manipulation in Excel but I though a spreadsheet that supports a million rows should be able to handle large data sets. I was really looking to get some feedback from users of larger data sets on their performance observations. Thanks "Jon Peltier" wrote: You've posted this already, and some people have agreed that there are performance issues in some of Excel's operations. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Concerned" wrote in message ... I have a Centrino Duo T2300 with 1 Gig of Ram and loaded the demo version of Offict 2007 Professional. I have a 15 Meg spreadsheet created in Excel 2003 which I loaded and saved it in Excel 2007. It has a number of graph tabs. When I press a graph tab it takes almost 5 seconds to switch between tabs. This was almost instantaneous on 2003. It this the expected performance. In addition the the memory size increases significantly with each graph tab and is currently sitting at over 400 Meg. Spreadsheed is ~ 8300 rows of data (345 days of hourly data). The recalculation is turned off and I need to do a simple X-Y plot of 5 variable versus time. To get graphs by month I have copied the same chart and change the X-Scale min/max values to show 1 month of data per Tab. the result is each graph displays ~750 data points of the 8300 defined in the graph range. In Excel 2003, the ability to switch tabs is "instantaneous" in Excel 2007 it takes ~5 seconds the first time and is shorter if it is reselected. Each tab that is selected used a significant chunch of memory. This makes Excel 2007 unusable to me and I have removed the Office 2007 Professional Trial version and have gone back to 2003 where I'll have to stay is this is Excel 2007's performance. For a spreadsheet that supports 1,000,000 rows, graphing of this data set should be a breeze not a significant slowdown from 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2007 Documents | Excel Worksheet Functions | |||
Excel 2003 Workbook I want to convert to Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 (Trial) Active X Problems | Excel Discussion (Misc queries) | |||
Excel 2003 performance problems | Excel Discussion (Misc queries) |