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: 1,670
Default Performance on calculation - 2003 vs 2007

Refer to http://www.decisionmodels.com/memlimitsc.htm

"Excel 2003 is officially limited to 1 Gigabyte (GB) of memory. This limit
appears to a limit on the working set memory used by bthe Excel process,
which is the memory reported by Windows Task Manager.

Excel 2007 is limited to 2 Gigabytes of memory for the Excel process under
Windows XP (Windows memory limit). This 2 Gigabyte limit is a limit on the
Virtual Memory address space. Virtual memory used by a process is larger than
the working set memory reported by Windows Task Manager, so the amount of
useable memory under Excel 2007 is considerably less than twice that of Excel
2003.
Because Excel 12 also requires more memory to store the indexes to the
increased number of rows and columns you may not be able to load larger
workbooks under Excel 2007 than was possible under Excel 2003."

Does it imply that Excel 2003 is little better than Excel 2007 on memory to
store the indexes to the increased number of rows and columns?
I work with a larger workbooks about 10 MB ~ 25 MB for office 2000 under
Window XP, If I upgrade to Excel 2003 / 2007, does anyone have any
suggestions on what the different in term of performance on calculation
speeds is about? Which one is performed faster on calculation? ignoring the
file size on memory to store the indexes, because I can change to larger HDD
over 250 GB.

Do you have any suggestions?
Thanks you for any suggestions
Eric
 
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
Very poor performance with Excel 2007 RossR Excel Discussion (Misc queries) 3 March 29th 07 12:12 AM
Am I the Only One Having Excel 2007 Performance Problems Concerned Excel Discussion (Misc queries) 4 January 30th 07 01:17 AM
Excel performance calculation JE McGimpsey Excel Worksheet Functions 3 July 19th 06 03:37 AM
Performance not upto Office 2003 standards in Office 2007 Mangal Singh Excel Discussion (Misc queries) 11 May 30th 06 12:57 AM
annualized return calculation for the purpose of portfolio performance evaluation sharkey Excel Worksheet Functions 2 April 8th 06 09:41 PM


All times are GMT +1. The time now is 06:06 PM.

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"