Excel Frequent Crashes

[Geoff Lilley]

Hi all. I've had a spate of Excel unexpectedly quitting recently, and I
wanted some advice.

I've applied the latest updates, and repaired disk permissions after so
doing.

Excel tends to quit when I'm running a macro that loops through multiple
worksheets in a book, updating PivotTables.

The other time I get Excel quitting unexpectedly on a fairly consistent
basis is in the following sequence of events:
1) I record a one-off macro, and store it to the Personal Macro Workbook
2) I go to quit Excel
3) I get prompted to save changes to the Personal Macro Workbook, and I
say yes.

I then get the error message.

No other applications causing me problems, but I spend 10-12 hours a day
in just Excel, so I don't know what to make of that.

I have a MacBook Pro, OS X 10.4.8, 2 GB of RAM, 2.16 Intel Core Duo, all
latest software updates applied, which I do religiously.

Any advice?

TIA
Geoff

 

[Bob Greenblatt]

Hi all. I've had a spate of Excel unexpectedly quitting recently, and I
wanted some advice.

I've applied the latest updates, and repaired disk permissions after so
doing.

Excel tends to quit when I'm running a macro that loops through multiple
worksheets in a book, updating PivotTables.

The other time I get Excel quitting unexpectedly on a fairly consistent
basis is in the following sequence of events:
1) I record a one-off macro, and store it to the Personal Macro Workbook
2) I go to quit Excel
3) I get prompted to save changes to the Personal Macro Workbook, and I
say yes.

I then get the error message.

No other applications causing me problems, but I spend 10-12 hours a day
in just Excel, so I don't know what to make of that.

I have a MacBook Pro, OS X 10.4.8, 2 GB of RAM, 2.16 Intel Core Duo, all
latest software updates applied, which I do religiously.

Any advice?

TIA
Geoff

Geoff,

Can you step through your macro to see where it crashes? Was either the
workbook you are working on, or your personal macro workbook ever updated on
windows Excel? Have you ever "cleaned" your macro project? --> Save all the
macro code to a text file. Delete all modules. Save and close the workbook
and then Excel. Reopen the workbook and paste in the macro code from the
saved text.

 

[Geoff Lilley]

Geoff,

Can you step through your macro to see where it crashes? Was either the
workbook you are working on, or your personal macro workbook ever updated on
windows Excel? Have you ever "cleaned" your macro project? --> Save all the
macro code to a text file. Delete all modules. Save and close the workbook
and then Excel. Reopen the workbook and paste in the macro code from the
saved text.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom- Hide quoted text -

- Show quoted text -

Good idea. Yeah, I can step through it. Most of my macros fail/crash
Excel if they try to change a page field's value, and can't find the
page field by the name I pass to in the argument.

I've had less crashes since I "cleaned" the modules that I'm not using
anymore. I should probably do that for the remainder just for
safety's sake.

Thanks for the advice, Bob. You're a good man.

Cheers
Geoff

 

[Geoff Lilley]

Geoff,

Can you step through your macro to see where it crashes? Was either the
workbook you are working on, or your personal macro workbook ever updated on
windows Excel? Have you ever "cleaned" your macro project? --> Save all the
macro code to a text file. Delete all modules. Save and close the workbook
and then Excel. Reopen the workbook and paste in the macro code from the
saved text.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom- Hide quoted text -

- Show quoted text -

PS - if it helps anything, the other way I can get XL to crash VERY
reliably is if I have a VLOOKUP function or another lookup function
(INDEX, MATCH, etc) referencing a second worksheet. When I go to
highlight the cells in the other worksheet, it crashes. Does that
tell you anything?)

Geoff

 

[Bob Greenblatt]

PS - if it helps anything, the other way I can get XL to crash VERY
reliably is if I have a VLOOKUP function or another lookup function
(INDEX, MATCH, etc) referencing a second worksheet. When I go to
highlight the cells in the other worksheet, it crashes. Does that
tell you anything?)

Geoff

It tells me that something is screwy with your configuration. This works
fine for me and always has.