Excel (2003 SP2) Closes ... Sorry for the Inconvenience !

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

monir - 10 Apr 2006 19:37 GMT

(I did post this last week, but apparently it did not go through)

Hello;

Recently, I've ocassionally been getting the following Excel message:
"Microsoft Excel for Windows has encountered a problem and needs to close.
We are sorry for the inconvenience", with options to "Send error Report" or
"Don't Send".
Sending error reports does not appear (so far) to solve the problem !!!

1. Can someone please advise on how to get rid of this annoying message ?
2. If some Excel files are corrupt, can Excel be repaired ? (see below)
3. Do I've to re-install Excel ?
4. Do you need more info. about the message ? ... so that next time the
message pops up, I write down relevant notes, though not too much details are
displayed with the message.

The problem appears to be associated with a particular file, myBook.xls.
The file works perfectly if it's the only open file. If it's open with other
files, then there's a good chance the error message would appear.

I've tried "Detect and Repair", as well as "Open and Repair" on the
individual files, with no avail.

Thank you kindly.

Reply to this Message

Nick Hodge - 10 Apr 2006 20:41 GMT

If it's only one file I would suspect the file and I would copy over as much
as possible to a new one.

Sending the error report will not fix the problem, it just advises MS of the
issue if it hasn't happened before and if it has, now many times to
determine if they need to fix it.

If changing the file out does noy fix it, try getting the first few
sentences of the error message may help

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> (I did post this last week, but apparently it did not go through)
>
[quoted text clipped - 24 lines]
>
> Thank you kindly.

Reply to this Message

monir - 10 Apr 2006 21:34 GMT

Nick;
By copying over the suspected file to a new one, do you mean using
copy/paste every w/s, every chart, every module, every events, etc. ?

Your help is greatly appreciated.

> If it's only one file I would suspect the file and I would copy over as much
> as possible to a new one.
[quoted text clipped - 34 lines]
> >
> > Thank you kindly.

Reply to this Message

Nick Hodge - 10 Apr 2006 23:27 GMT

If it has that amount of stuff in it, I suspect it's corrupting, but yes,
you would do well to transfer everything over and even save off a few copies
in case it suddenly stops allowing you in

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Nick;
> By copying over the suspected file to a new one, do you mean using
[quoted text clipped - 47 lines]
>> >
>> > Thank you kindly.

Reply to this Message

monir - 11 Apr 2006 01:47 GMT

Nick;
I've just completed the copying over and tested the new file.
Again, the copied file works perfectly if it's the only open file, and does
all the computations as desired. If it's open with other Excel files, then
the annoying message "Excel needs to close ... Sorry for the inconvenience"
would appear either at the start or later. The other similarly structured
files work absolutely perfect individually and when opened simultaneously.
It's only myBook.xls which appears to be the problem!!

The error message does not say much. Here is the exact error message, with
the hope that you, with your expertise, might be able to read between the
lines:
..."Microsoft Office Excel
.......Microsoft Office Excel has encountered a problem and needs to close.
We are sorry for the inconvenience.
...The information you were working on might be lost. Mictosoft Office Excel
can try to recover it for you.
...Please tell Microsoft about this problem.
...We have created an error report that you can send to help us improve
Microsoft Office Excel. We will treat this report as confidential and
anonymous.
......................Send Report..............................Don't
Send................................"

As I indicated earlier, sending the error report does not appear (so far) to
generate an MS response. I've probably sent 10 - 20 Reports already.

Would you be interested in some of the gibberish data contained in the
Report ? Any keywords to look for?

Thank you.

> If it has that amount of stuff in it, I suspect it's corrupting, but yes,
> you would do well to transfer everything over and even save off a few copies
[quoted text clipped - 51 lines]
> >> >
> >> > Thank you kindly.

Reply to this Message

monir - 11 Apr 2006 03:39 GMT

Here is another piece of the puzzle!
The suspected file myBook.xls does not only work perfectly if it's opened
alone, but also if it's opened first. If myBook.xls is opened while any (or
all) of the other 4 identically structured workbooks is opened, the error
message "Excel needs to close ..." would appear!

Each of the 5 w/bs, including myBook.xls, has the following ThisWorkbook
open event:
=============================================
Private Sub workbook_open()
ActiveWindow.WindowState = xlMaximized
Sheets("Pick-Up Scenario").Select
Range("A1").Select
'
' Nov 27, 05 on Toshiba. The following Auto_Open is inserted to solve the
problem:
' " Solver: An unexpected internal error occured, or available memory was
' exhausted"
' This error occured when trying to run any Solver vba macro from a button.
' I truly don't know why, since the procedure worked fine on the IBM desktop
w/o
' this statement.

Application.Run "Solver.xla!Auto_Open"
End Sub
=============================================

Commenting the above Auto_Open did not solve the the "Excel needs to close
...".
Please keep in mind that the other 4 w/bs work perfectly, individually and
in any open sequence combination.

> Nick;
> I've just completed the copying over and tested the new file.
[quoted text clipped - 85 lines]
> > >> >
> > >> > Thank you kindly.

Reply to this Message

Nick Hodge - 12 Apr 2006 07:49 GMT

Monir

Try downloading Rob Bovey's code cleaner from

http://www.appspro.com/Utilities/CodeCleaner.htm

Maybe the code is corrupted

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Here is another piece of the puzzle!
> The suspected file myBook.xls does not only work perfectly if it's opened
[quoted text clipped - 139 lines]
>> > >> >
>> > >> > Thank you kindly.

Reply to this Message

monir - 14 Apr 2006 00:33 GMT

Nick;
Thanks for the ref. to the Bovey's code cleaner. Never heard of the concept
before, but will try it. Sounds a great idea!! Do you use it often on large
files?

> Monir
>
[quoted text clipped - 147 lines]
> >> > >> >
> >> > >> > Thank you kindly.

Reply to this Message

John Lyons - 12 Apr 2006 17:01 GMT

Had this happen myself a while back. If the file is big, with a lot of
formulae, could be using all the CPU for calculation. This would explain why
you have probs opening files afterwards, but not before (until you open this
one). My workaround was to copy & paste value formulae, and copy the formulae
when I needed to recalculate.

> (I did post this last week, but apparently it did not go through)
>
[quoted text clipped - 21 lines]
>
> Thank you kindly.

Reply to this Message

monir - 13 Apr 2006 02:31 GMT

Hi;
I've copied over the entire w/b to a new one, with no luck! The problem
file myBook.xls is considerably smaller than the other 4 error-free files.
Here's a summary which might help describing the problem:

1. myBook.xls works perfectly when opened alone or opened first.
2. If myBook.xls is opened after opening any or all of the other 4
identically structured files, the error message "Excel needs to close ...
Sorry for the inconvenience" appears, and shuts Excel down .
3. All of the other 4 identically structured files work perfectly,
individually and in whatever order they're opened.
4. If I include the statement Application.EnableEvents = False in myBook.xls
ThisWorkbook Open event, the error message no longer appears !! (at the
expense of disabling all the events, and thus rendering the w/b
non-functional).
5. Alternatively, instead of disabling the events (4. above), if I delete
Sheet1 from myBook.xls, the error message also ceases to pop up!! (similarly,
at the expense of redering the w/b non-functional).
6. In conjunction of 5. above, I've recreated Sheet1 from scratch.
Unfortunately, with the same problem as 2. above.

Your suggestion(s) would be greatly appreciated.

> Had this happen myself a while back. If the file is big, with a lot of
> formulae, could be using all the CPU for calculation. This would explain why
[quoted text clipped - 27 lines]
> >
> > Thank you kindly.

Reply to this Message

monir - 14 Apr 2006 00:36 GMT

code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' changes active cell to yellow. If it was yellow, change it to white
' for cells row 10, columns 5 to 10
Range("L10") = ""
myInteriorColor = 15 'Gray 25% if there is a scenario
If ActiveCell.Row = 10 Then
If ActiveCell.Column >= 5 And ActiveCell.Column <= 10 Then
If ActiveCell.Interior.Color <> vbYellow Then
ActiveCell.Interior.Color = vbYellow
Else
ActiveCell.Interior.Color = vbWhite
End If
End If
End If
'
' determine the relevant scenario based on the selected yellow cells
If Range("D10:G10").Interior.ColorIndex = 6 Then
If Range("I10").Interior.ColorIndex = 6 And
Range("H10,J10").Interior.ColorIndex = 2 Then
Range("L10") = "1"
GoTo myLabel
Else
If Range("J10").Interior.ColorIndex = 6 And
Range("H10,I10").Interior.ColorIndex = 2 Then
Range("L10") = "2"
GoTo myLabel
End If
End If
End If
If Range("D10:F10,H10:I10").Interior.ColorIndex = 6 And
Range("G10,J10").Interior.ColorIndex = 2 Then
Range("L10") = "3"
GoTo myLabel
End If
If Range("D10,E10,G10,J10").Interior.ColorIndex = 6 And
Range("F10,H10:I10").Interior.ColorIndex = 2 Then
Range("L10") = "8"
GoTo myLabel
End If
If Range("D10,E10,G10,I10,J10").Interior.ColorIndex = 6 And
Range("F10,H10").Interior.ColorIndex = 2 Then
Range("L10") = "9"
GoTo myLabel
End If

Range("L10") = "unrealistic"
myInteriorColor = 3 'Red

myLabel:
With Range("L10").Interior
.ColorIndex = myInteriorColor
.Pattern = xlSolid
End With
Range("B10").Select ' comment to make changes on sheet
End Sub

The problem has now been narrowed down to the above SelectionChange event in
Sheet1 of myBook.xls. When the SC is commented out (myBook1.xls), the message
"Excel needs to close ..." does not pop up anymore!!
This's done primarily to identify the cause of the problem, at the expense
of rendering the w/b mybook1.xls non-functional.
Although the 5 w/bs are identically structured (i.e.; exact modules, exact
w/b and w/s events procedures, exact format, exact layout, exact macros,
etc.), and the 4 w/bs work fine (individually, and when opened in any order),
it appears that, for whatever reason, the identical SelectionChange event in
Sheet1, in and only in myBook.xls, is the cause of the problem when
myBook.xls is not opened alone or if it's not opened first. Otherwise, it
works perfectly with no problem !!!!

I'm sure many of you could easily re-write the above simple SelectionChange
code, and I would certainly appreciate that, but I suspect it's the SC event
and not its code is the problem. Correct ??

I would appreciate any suggestion that would get me out of this confusion.
Thank you.

> Hi;
> I've copied over the entire w/b to a new one, with no luck! The problem
[quoted text clipped - 50 lines]
> > >
> > > Thank you kindly.

Reply to this Message

fred - 31 Jul 2007 21:46 GMT

> (I did post this last week, but apparently it did not go through)
>
[quoted text clipped - 21 lines]
>
> Thank you kindly.

Reply to this Message

fred - 31 Jul 2007 21:50 GMT

> (I did post this last week, but apparently it did not go through)
>
[quoted text clipped - 21 lines]
>
> Thank you kindly.

I now have the same error message open on my Excel. What can I do to save
all the data i just worked on without losing everything. Please tell me
there's something I can do now to prevent losing all my work. I am very
hesitant to click on the SEND or DON'T SEND command box. What do I do.
Thanks.>

Reply to this Message