Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Excel Beta 2007 on PC: unable to handle very large workbooks?

2 points. 1. 102MB XLS file slows down the Beta to a crawl. Like 5 minutes to
open it. Is this unusual or par for the course? And I have a DuoCore!

2. When saving as an XLSX file it's size is only 1.5MB. Is this common? How
does it do that?

Victor
This is Excel Beta version: 12.0.4017.1004
My system is:
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 2 Build 2600
OS Manufacturer Microsoft Corporation
System Name xxxxxxxxxxx
System Manufacturer Hewlett-Packard
System Model HP Pavilion dv8000
System Type X86-based PC
Processor x86 Family 6 Model 14 Stepping 8 GenuineIntel ~1828 Mhz
Processor x86 Family 6 Model 14 Stepping 8 GenuineIntel ~1828 Mhz
BIOS Version/Date Hewlett-Packard F.13, 5/10/2006
SMBIOS Version 2.4
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.1.2600.2765 (xpsp.050928-1517)"
User Name xxxxxxxxxxxxx
Time Zone Pacific Standard Time
Total Physical Memory 2,048.00 MB
Available Physical Memory 1.29 GB
Total Virtual Memory 2.00 GB
Available Virtual Memory 1.96 GB
Page File Space 3.85 GB
Page File C:\pagefile.sys

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Excel Beta 2007 on PC: unable to handle very large workbooks?

As for file sizes: I've opened 100mb+ files very qucikly in XL 2007. Does
your data have a lot of cells calculating? That could explain why it takes
so long to open.

As for the XLSX file format: as I understand it, this is an XML-based file
format, which apparently dramatically reduces the file size.

If you want more information on either of these two issues, a good place to
start looking would be the XL 2007 developers' blog, which can be found he
http://blogs.msdn.com/excel/

Not that many regular participants on this forum are familiar with XL 2007,
so you'll probably find better info at the blog link I give.

Dave
--
Brevity is the soul of wit.


"victor" wrote:

2 points. 1. 102MB XLS file slows down the Beta to a crawl. Like 5 minutes to
open it. Is this unusual or par for the course? And I have a DuoCore!

2. When saving as an XLSX file it's size is only 1.5MB. Is this common? How
does it do that?

Victor
This is Excel Beta version: 12.0.4017.1004
My system is:
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 2 Build 2600
OS Manufacturer Microsoft Corporation
System Name xxxxxxxxxxx
System Manufacturer Hewlett-Packard
System Model HP Pavilion dv8000
System Type X86-based PC
Processor x86 Family 6 Model 14 Stepping 8 GenuineIntel ~1828 Mhz
Processor x86 Family 6 Model 14 Stepping 8 GenuineIntel ~1828 Mhz
BIOS Version/Date Hewlett-Packard F.13, 5/10/2006
SMBIOS Version 2.4
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.1.2600.2765 (xpsp.050928-1517)"
User Name xxxxxxxxxxxxx
Time Zone Pacific Standard Time
Total Physical Memory 2,048.00 MB
Available Physical Memory 1.29 GB
Total Virtual Memory 2.00 GB
Available Virtual Memory 1.96 GB
Page File Space 3.85 GB
Page File C:\pagefile.sys

Reply
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
Do Large Workbooks Still Crash in Excel 2007 MrHugeWorksheets Excel Discussion (Misc queries) 0 October 2nd 06 11:09 PM
In Excel 2007 Unable to view or print text box [email protected] Excel Discussion (Misc queries) 2 September 27th 06 02:55 PM
How do I print charts in Excel 2007 beta? dewbet Excel Discussion (Misc queries) 1 August 21st 06 03:33 PM
MSN Stock Quotes in Excel 2007 Beta Trader_in_Paradise Excel Discussion (Misc queries) 0 June 7th 06 09:44 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM


All times are GMT +1. The time now is 02:38 AM.

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

About Us

"It's about Microsoft Excel"