random crash

[mctwist]

Hi all, I have a customer working in Excel for various things, but one
of them is his price list. Right now he as Office 2003 installed with
SP2 (11.8142.8132). As far as I know, the updates are all done (he's
got Microsoft Update installed).

For some reason, he will sometime work in Excel all day long without a
problem (yesterday), but other days he'll be crashing really often,
preventing him to do his job.

Here's what he's working with. He's got this Excel spreadsheet that's
about 440MB in size, with about 20 different sheets. 3 of them have
about 40000+ lines in them, with margin calculation and a link to an
external spreasheet (margin table) for his margin rates. It will not
always crash while doing the same thing, for exemple sometimes it will
crash while he's adding a column (40000+ records), it might crash on a
sort, it will even crash if he tries to resize a column so that he can
see all the data.

I'm really at a loss here as to what could cause the crash, he's got a
brand new machine with an Intel Core 2 Duo, 1GB RAM, WinXP Pro, and it
doesn't crash anywhere else.

Here's the 2 errors I have in the application log when it crashes:

Event Type: Error

Event Source: Application Hang

Event Category: None

Event ID: 1001

Date: 27/07/2007

Time: 12:29:37 PM

User: N/A

Computer: STATION205

Description:

Fault bucket 458157789.



For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 42 75 63 6b 65 74 3a 20 Bucket:

0008: 34 35 38 31 35 37 37 38 45815778

0010: 39 0d 0a 9..





Event Type: Error

Event Source: Application Hang

Event Category: (101)

Event ID: 1002

Date: 27/07/2007

Time: 12:28:20 PM

User: N/A

Computer: STATION205

Description:

Hanging application EXCEL.EXE, version 11.0.8142.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.

Data:

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 31 2e 30 EXE 11.0

0020: 2e 38 31 34 32 2e 30 20 .8142.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

0038: 2e 30 20 61 74 20 6f 66 .0 at of

0040: 66 73 65 74 20 30 30 30 fset 000

0048: 30 30 30 30 30 00000



Hopefully I can get a fix for this client, as this is a big part of
his daily job...

Thanks,

Stephane

 

[Jim Cone]

Let me take a stab at it...
440 MB is the largest Excel workbook I have ever heard of.
It is about ten times larger then what I would consider an out of control upper limit.
The first thing is do is make sure that the file is backed up.
(don't be surprised if your next call is "the file won't open")
Then start in on reducing the file size.
There is some good advice here...
http://www.decisionmodels.com/optspeedd.htm#Size
Clean out the machines %temp% file.
Delete (not clear) all rows and columns below and to the right of the last
cell with data (on each sheet). Usually the workbook must
be saved afterwards to see the difference.
Check for multiple unused graphic objects...
"Edit | Go To | Special (button) | Objects - I received a workbook from
a client once that had 1100 pictures stacked one on top of the other.
Think seriously about a workbook redesign.
Good luck,
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


I would say the file size is the cause of the problem.
Hi all, I have a customer working in Excel for various things, but one
of them is his price list. Right now he as Office 2003 installed with
SP2 (11.8142.8132). As far as I know, the updates are all done (he's
got Microsoft Update installed).

For some reason, he will sometime work in Excel all day long without a
problem (yesterday), but other days he'll be crashing really often,
preventing him to do his job.

Here's what he's working with. He's got this Excel spreadsheet that's
about 440MB in size, with about 20 different sheets. 3 of them have
about 40000+ lines in them, with margin calculation and a link to an
external spreasheet (margin table) for his margin rates. It will not
always crash while doing the same thing, for exemple sometimes it will
crash while he's adding a column (40000+ records), it might crash on a
sort, it will even crash if he tries to resize a column so that he can
see all the data.

I'm really at a loss here as to what could cause the crash, he's got a
brand new machine with an Intel Core 2 Duo, 1GB RAM, WinXP Pro, and it
doesn't crash anywhere else.

Here's the 2 errors I have in the application log when it crashes:

Event Type: Error

Event Source: Application Hang

Event Category: None

Event ID: 1001

Date: 27/07/2007

Time: 12:29:37 PM

User: N/A

Computer: STATION205

Description:

Fault bucket 458157789.



For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 42 75 63 6b 65 74 3a 20 Bucket:

0008: 34 35 38 31 35 37 37 38 45815778

0010: 39 0d 0a 9..





Event Type: Error

Event Source: Application Hang

Event Category: (101)

Event ID: 1002

Date: 27/07/2007

Time: 12:28:20 PM

User: N/A

Computer: STATION205

Description:

Hanging application EXCEL.EXE, version 11.0.8142.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.

Data:

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 31 2e 30 EXE 11.0

0020: 2e 38 31 34 32 2e 30 20 .8142.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

0038: 2e 30 20 61 74 20 6f 66 .0 at of

0040: 66 73 65 74 20 30 30 30 fset 000

0048: 30 30 30 30 30 00000



Hopefully I can get a fix for this client, as this is a big part of
his daily job...

Thanks,

Stephane

 

[mctwist]

Let me take a stab at it...
440 MB is the largest Excel workbook I have ever heard of.
It is about ten times larger then what I would consider an out of control upper limit.
The first thing is do is make sure that the file is backed up.
(don't be surprised if your next call is "the file won't open")
Then start in on reducing the file size.
There is some good advice here...
http://www.decisionmodels.com/optspeedd.htm#Size
Clean out the machines %temp% file.
Delete (not clear) all rows and columns below and to the right of the last
cell with data (on each sheet). Usually the workbook must
be saved afterwards to see the difference.
Check for multiple unused graphic objects...
"Edit | Go To | Special (button) | Objects - I received a workbook from
a client once that had 1100 pictures stacked one on top of the other.
Think seriously about a workbook redesign.
Good luck,
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


Hi all, I have a customer working in Excel for various things, but one
of them is his price list. Right now he as Office 2003 installed with
SP2 (11.8142.8132). As far as I know, the updates are all done (he's
got Microsoft Update installed).

For some reason, he will sometime work in Excel all day long without a
problem (yesterday), but other days he'll be crashing really often,
preventing him to do his job.

Here's what he's working with. He's got this Excel spreadsheet that's
about 440MB in size, with about 20 different sheets. 3 of them have
about 40000+ lines in them, with margin calculation and a link to an
external spreasheet (margin table) for his margin rates. It will not
always crash while doing the same thing, for exemple sometimes it will
crash while he's adding a column (40000+ records), it might crash on a
sort, it will even crash if he tries to resize a column so that he can
see all the data.

I'm really at a loss here as to what could cause the crash, he's got a
brand new machine with an Intel Core 2 Duo, 1GB RAM, WinXP Pro, and it
doesn't crash anywhere else.

Here's the 2 errors I have in the application log when it crashes:

Event Type: Error

Event Source: Application Hang

Event Category: None

Event ID: 1001

Date: 27/07/2007

Time: 12:29:37 PM

User: N/A

Computer: STATION205

Description:

Fault bucket 458157789.

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Data:

0000: 42 75 63 6b 65 74 3a 20 Bucket:

0008: 34 35 38 31 35 37 37 38 45815778

0010: 39 0d 0a 9..

Event Type: Error

Event Source: Application Hang

Event Category: (101)

Event ID: 1002

Date: 27/07/2007

Time: 12:28:20 PM

User: N/A

Computer: STATION205

Description:

Hanging application EXCEL.EXE, version 11.0.8142.0, hang module
hungapp, version 0.0.0.0, hang address 0x00000000.

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Data:

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 31 2e 30 EXE 11.0

0020: 2e 38 31 34 32 2e 30 20 .8142.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

0038: 2e 30 20 61 74 20 6f 66 .0 at of

0040: 66 73 65 74 20 30 30 30 fset 000

0048: 30 30 30 30 30 00000

Hopefully I can get a fix for this client, as this is a big part of
his daily job...

Thanks,

Stephane

Alright, I will try and do that, but I'm not sure at how much in size
I can reduce it. As far as losing data, it's not that bad, as the
spreadsheet is used to calculate the price list for the dealers (my
client is a parts distributor), and then uploaded into their CRM
software, so it's basically a temp file.

 

[mctwist]

Alright, I will try and do that, but I'm not sure at how much in size
I can reduce it. As far as losing data, it's not that bad, as the
spreadsheet is used to calculate the price list for the dealers (my
client is a parts distributor), and then uploaded into their CRM
software, so it's basically a temp file.- Hide quoted text -

- Show quoted text -

Alright, I just talked to my customer this morning, and he think he
might have found something by accident. He started a new worksheet and
it still would crash. For some reason, he removed an average operation
from the worksheet (it was trying to calculate an average for 40000+
items). I'm not sure if it'll fix it, but I'll wait and see.

Stephane