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

(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.

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

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


"monir" <monir@discussions.microsoft.com> wrote in message
news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
> (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.
>

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.



"Nick Hodge" wrote:

> 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
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "monir" <monir@discussions.microsoft.com> wrote in message
> news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
> > (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.
> >
>
>
>

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

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


"monir" <monir@discussions.microsoft.com> wrote in message
news:5CC5941F-A1D1-4FB4-90D1-B3DEE7E99F92@microsoft.com...
> 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.
>
>
>
> "Nick Hodge" wrote:
>
>> 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
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> www.nickhodge.co.uk
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "monir" <monir@discussions.microsoft.com> wrote in message
>> news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
>> > (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.
>> >
>>
>>
>>

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.




"Nick Hodge" wrote:

> 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
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "monir" <monir@discussions.microsoft.com> wrote in message
> news:5CC5941F-A1D1-4FB4-90D1-B3DEE7E99F92@microsoft.com...
> > 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.
> >
> >
> >
> > "Nick Hodge" wrote:
> >
> >> 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
> >>
> >> --
> >> HTH
> >> Nick Hodge
> >> Microsoft MVP - Excel
> >> Southampton, England
> >> www.nickhodge.co.uk
> >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >>
> >>
> >> "monir" <monir@discussions.microsoft.com> wrote in message
> >> news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
> >> > (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.
> >> >
> >>
> >>
> >>
>
>
>

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.


"monir" wrote:

> 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.
>
>
>
>
> "Nick Hodge" wrote:
>
> > 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
> >
> > --
> > HTH
> > Nick Hodge
> > Microsoft MVP - Excel
> > Southampton, England
> > www.nickhodge.co.uk
> > nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >
> >
> > "monir" <monir@discussions.microsoft.com> wrote in message
> > news:5CC5941F-A1D1-4FB4-90D1-B3DEE7E99F92@microsoft.com...
> > > 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.
> > >
> > >
> > >
> > > "Nick Hodge" wrote:
> > >
> > >> 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
> > >>
> > >> --
> > >> HTH
> > >> Nick Hodge
> > >> Microsoft MVP - Excel
> > >> Southampton, England
> > >> www.nickhodge.co.uk
> > >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> > >>
> > >>
> > >> "monir" <monir@discussions.microsoft.com> wrote in message
> > >> news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
> > >> > (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.
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >

Monir

Try downloading Rob Bovey's code cleaner from

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

Maybe the code is corrupted

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


"monir" <monir@discussions.microsoft.com> wrote in message
news:225A2609-20D9-4DD3-AFCB-BCB64E0F3957@microsoft.com...
> 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.
>
>
> "monir" wrote:
>
>> 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.
>>
>>
>>
>>
>> "Nick Hodge" wrote:
>>
>> > 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
>> >
>> > --
>> > HTH
>> > Nick Hodge
>> > Microsoft MVP - Excel
>> > Southampton, England
>> > www.nickhodge.co.uk
>> > nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>> >
>> >
>> > "monir" <monir@discussions.microsoft.com> wrote in message
>> > news:5CC5941F-A1D1-4FB4-90D1-B3DEE7E99F92@microsoft.com...
>> > > 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.
>> > >
>> > >
>> > >
>> > > "Nick Hodge" wrote:
>> > >
>> > >> 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
>> > >>
>> > >> --
>> > >> HTH
>> > >> Nick Hodge
>> > >> Microsoft MVP - Excel
>> > >> Southampton, England
>> > >> www.nickhodge.co.uk
>> > >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>> > >>
>> > >>
>> > >> "monir" <monir@discussions.microsoft.com> wrote in message
>> > >> news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
>> > >> > (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.
>> > >> >
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >

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.

"monir" wrote:

> (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.
>

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.


"John Lyons" wrote:

> 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.
>
> "monir" wrote:
>
> > (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.
> >

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?


"Nick Hodge" wrote:

> Monir
>
> Try downloading Rob Bovey's code cleaner from
>
> http://www.appspro.com/Utilities/CodeCleaner.htm
>
> Maybe the code is corrupted
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "monir" <monir@discussions.microsoft.com> wrote in message
> news:225A2609-20D9-4DD3-AFCB-BCB64E0F3957@microsoft.com...
> > 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.
> >
> >
> > "monir" wrote:
> >
> >> 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.
> >>
> >>
> >>
> >>
> >> "Nick Hodge" wrote:
> >>
> >> > 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
> >> >
> >> > --
> >> > HTH
> >> > Nick Hodge
> >> > Microsoft MVP - Excel
> >> > Southampton, England
> >> > www.nickhodge.co.uk
> >> > nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >> >
> >> >
> >> > "monir" <monir@discussions.microsoft.com> wrote in message
> >> > news:5CC5941F-A1D1-4FB4-90D1-B3DEE7E99F92@microsoft.com...
> >> > > 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.
> >> > >
> >> > >
> >> > >
> >> > > "Nick Hodge" wrote:
> >> > >
> >> > >> 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
> >> > >>
> >> > >> --
> >> > >> HTH
> >> > >> Nick Hodge
> >> > >> Microsoft MVP - Excel
> >> > >> Southampton, England
> >> > >> www.nickhodge.co.uk
> >> > >> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >> > >>
> >> > >>
> >> > >> "monir" <monir@discussions.microsoft.com> wrote in message
> >> > >> news:C86108F5-D7A0-45A6-8248-DC1A6403FEAC@microsoft.com...
> >> > >> > (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.
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
>
>
>