LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel 2007 Documents Jim Excel Worksheet Functions 8 January 27th 07 12:08 AM
Excel 2003 Workbook I want to convert to Excel 2007 pglufkin Excel Discussion (Misc queries) 3 December 18th 06 07:06 PM
Excel 2007 (Trial) Active X Problems Don Excel Discussion (Misc queries) 0 December 15th 06 11:06 PM
Excel 2003 performance problems bjarvis Excel Discussion (Misc queries) 0 September 28th 05 08:27 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"