Excel hangs saving large files
QB-Paladin Thread Starter
Joined: Aug 21, 2003 Messages: 15
I've got a PC on my network running Windows XP Pro and Office XP. When attempting to save extremely large Excel files (one is 13MB and the other is 72MB - they're full of $@$#@ charts) to a network folder, Excel locks up. Additionally, when the user opens these files, it's common for Excel to report it's repairing the file. Saving to the local hard drive works fine.
This mess seemed to start after we upgraded our NT4 file server to Windows Server 2003. The Windows Server 2003 was set up by a MSCE, which I am not. I'm self taught, and this is my first exposure to server operating systems beyond NT4. The server is configured to be a DNS and PDC, as well as Active Directory. It's the only Windows server we have.
Event Type: Error
Hanging application EXCEL.EXE, version 10.0.4109.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 48 61 6e 67 ion Hang
0010: 20 20 45
58 43 45 4c 2e EXCEL.
0018: 45 58 45 20 31 30 2e 30 EXE 10.0
0020: 2e 34 31 30 39 2e 30 20 .4109.0
0028: 69 6e 20 68 75 6e 67 61 in hunga
0030: 70 70 20 30 2e 30 2e 30 pp 0.0.0
I assume the problems are related, but I'm not sure how or why. Saving non-Excel files seems to work ok, although nothing else approaches these two spreadsheets in file size. Saving Excel files smaller than 2MB seems to work fine. I haven't tried any files between 2MB and 13MB to see if/when I can hit a file size where the lockups start. The XP machine is configured to use the server as it's primary DNS.
The XP Pro machine is a P4-1.8 with 512MB and a 40GB hard drive that's no where near capacity. The server is running Dual P3-500's, has 256MB of RAM, and a 4 drive IDE-RAID array configured to 2 18GB striped/mirrored drives. Those are partitioned with the OS on a 2GB C: partition and data stored on the 16GB D: partition. The systems are connected via 10mbit Cat3 (the building's wiring is old and inaccessable, and wireless is unreliable due to the building's construction).Source: forums.techguy.org
Category: Personal Finance