Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks


  #3   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Hold the CTRL key when you open Excel

Say Yes in the dialog that say "Do you want to start Excel in Safe mode?"

Do you have the same problem now ?



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks



  #5   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks



  #7   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks




  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Run setup from the CD

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks




  #9   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss


"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks




  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Is it one workbook that have this problem ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss


"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks






  #11   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

Actually, this file is an Excel Template. It contains some 6 excel sheets
with in it.
It was created using Excel 2003.
Now, I have converted this template to Macro enabled excel template. (.XSLT)
in 2007.

we have some 10 users for this file. All of them are getting that error when
they are closing the form and I am sure that this is the only file that we
are facing this problem.



"Ron de Bruin" wrote:

Is it one workbook that have this problem ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss


"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks





  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Error with closing the Excel file

On Jan 30, 9:45 am, "Ron de Bruin" wrote:
Is it one workbook that have this problem ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"ss" wrote in ...
Ron,


I tried repair of office.
Still it is giving me the same error while closing the form.


can you suggest me any thing else to try?


TIA
ss


"ss" wrote:


How can I do a repair of Office?
Is there any tool within Office 2007 for this?


Thanks


"Ron de Bruin" wrote:


Try a repair of Office


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Yes,


I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:


Ron,


Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"


but, even after that also, It is giving me the same error.


Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.


what is wrong with this?


Thanks


"Ron de Bruin" wrote:


Hi ss


Try this first


Run Office Diagnostics.
Office ButtonExcel Options...Resources


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Hi,


I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?


Thanks


I am having the same problem. My Excel 2007 is an upgrade from 2003
(which thankfully is still installed). I did, however, discover that
if I have macros in my workbook, or if I just bring up the macro
editor (alt-F11), no problem occurs when I close the file. I'm not
suggesting this as a workaround but only offer it as another clue.

Don
  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Can you send me the file private ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Actually, this file is an Excel Template. It contains some 6 excel sheets
with in it.
It was created using Excel 2003.
Now, I have converted this template to Macro enabled excel template. (.XSLT)
in 2007.

we have some 10 users for this file. All of them are getting that error when
they are closing the form and I am sure that this is the only file that we
are facing this problem.



"Ron de Bruin" wrote:

Is it one workbook that have this problem ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss


"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks





  #14   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default Error with closing the Excel file

,

you are right. when I am closing the file by opening the VBA window side by
it, it is not giving me the error.



" wrote:

On Jan 30, 9:45 am, "Ron de Bruin" wrote:
Is it one workbook that have this problem ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"ss" wrote in ...
Ron,


I tried repair of office.
Still it is giving me the same error while closing the form.


can you suggest me any thing else to try?


TIA
ss


"ss" wrote:


How can I do a repair of Office?
Is there any tool within Office 2007 for this?


Thanks


"Ron de Bruin" wrote:


Try a repair of Office


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in ...
Yes,


I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:


Ron,


Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"


but, even after that also, It is giving me the same error.


Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.


what is wrong with this?


Thanks


"Ron de Bruin" wrote:


Hi ss


Try this first


Run Office Diagnostics.
Office ButtonExcel Options...Resources


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Hi,


I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?


Thanks


I am having the same problem. My Excel 2007 is an upgrade from 2003
(which thankfully is still installed). I did, however, discover that
if I have macros in my workbook, or if I just bring up the macro
editor (alt-F11), no problem occurs when I close the file. I'm not
suggesting this as a workaround but only offer it as another clue.

Don

  #15   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Hi ss

After a lot of testing in your workbook I found the problem

The problem is that you use pictures instead of buttons to run your macro's.
Excel 2007 not like that.
The only way to avoid this problem is to replace the pictures for Forms ot ActiveX buttons I think.
I will test more and if there is another option I post back

I will create a bug report for this and send it to MS


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message ...
,

you are right. when I am closing the file by opening the VBA window side by
it, it is not giving me the error.



" wrote:

On Jan 30, 9:45 am, "Ron de Bruin" wrote:
Is it one workbook that have this problem ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"ss" wrote in ...
Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss

"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in ...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.

"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.

what is wrong with this?

Thanks

"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in ...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?

Thanks


I am having the same problem. My Excel 2007 is an upgrade from 2003
(which thankfully is still installed). I did, however, discover that
if I have macros in my workbook, or if I just bring up the macro
editor (alt-F11), no problem occurs when I close the file. I'm not
suggesting this as a workaround but only offer it as another clue.

Don



  #16   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 230
Default Error with closing the Excel file

Ron,

Interesting. I have 2007 and a file I created also uses pictures to launch
a couple of macros without any problem.
But I do realise that each computer seems to find its own problems with this
version. I believe the 2007 Ultimate version doesn't have the same problems
as Professional, etc.

Rob

"Ron de Bruin" wrote in message
...
Hi ss

After a lot of testing in your workbook I found the problem

The problem is that you use pictures instead of buttons to run your
macro's.
Excel 2007 not like that.
The only way to avoid this problem is to replace the pictures for Forms ot
ActiveX buttons I think.
I will test more and if there is another option I post back

I will create a bug report for this and send it to MS


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message
...
,

you are right. when I am closing the file by opening the VBA window side
by it, it is not giving me the error. " wrote:

On Jan 30, 9:45 am, "Ron de Bruin" wrote:
Is it one workbook that have this problem ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"ss" wrote in
...
Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss

"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in
...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.

"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message
that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to
close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is
opening the blank
excel form.

what is wrong with this?

Thanks

"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in
...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft
Office Excel has
encountered a problem and needs to close. We are sorry for
the
inconvenience) and if I don't un-check "restart microsof
office" it will
restart Excel. What can this problem be?

Thanks

I am having the same problem. My Excel 2007 is an upgrade from 2003
(which thankfully is still installed). I did, however, discover that
if I have macros in my workbook, or if I just bring up the macro
editor (alt-F11), no problem occurs when I close the file. I'm not
suggesting this as a workaround but only offer it as another clue.

Don



  #17   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Error with closing the Excel file

Last info

If there is also Office 2003 installed on the machine there is no problem.
And the macro we use here close the workbook, a simple other macro will also work with only 2007 installed.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"RobN" wrote in message ...
Ron,

Interesting. I have 2007 and a file I created also uses pictures to launch
a couple of macros without any problem.
But I do realise that each computer seems to find its own problems with this
version. I believe the 2007 Ultimate version doesn't have the same problems
as Professional, etc.

Rob

"Ron de Bruin" wrote in message
...
Hi ss

After a lot of testing in your workbook I found the problem

The problem is that you use pictures instead of buttons to run your
macro's.
Excel 2007 not like that.
The only way to avoid this problem is to replace the pictures for Forms ot
ActiveX buttons I think.
I will test more and if there is another option I post back

I will create a bug report for this and send it to MS


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in message
...
,

you are right. when I am closing the file by opening the VBA window side
by it, it is not giving me the error. " wrote:

On Jan 30, 9:45 am, "Ron de Bruin" wrote:
Is it one workbook that have this problem ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"ss" wrote in
...
Ron,

I tried repair of office.
Still it is giving me the same error while closing the form.

can you suggest me any thing else to try?

TIA
ss

"ss" wrote:

How can I do a repair of Office?
Is there any tool within Office 2007 for this?

Thanks

"Ron de Bruin" wrote:

Try a repair of Office

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in
...
Yes,

I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.

"ss" wrote:

Ron,

Yes, I ran the Office diagnostics, I showed me the message
that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft Office Excel has encountered a problem and needs to
close. We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is
opening the blank
excel form.

what is wrong with this?

Thanks

"Ron de Bruin" wrote:

Hi ss

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"ss" wrote in
...
Hi,

I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft
Office Excel has
encountered a problem and needs to close. We are sorry for
the
inconvenience) and if I don't un-check "restart microsof
office" it will
restart Excel. What can this problem be?

Thanks

I am having the same problem. My Excel 2007 is an upgrade from 2003
(which thankfully is still installed). I did, however, discover that
if I have macros in my workbook, or if I just bring up the macro
editor (alt-F11), no problem occurs when I close the file. I'm not
suggesting this as a workaround but only offer it as another clue.

Don



  #18   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Error with closing the Excel file

On Jan 23, 10:03*pm, ss wrote:
Ron,

Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"

but, even after that also, It is giving me the same error.

Microsoft OfficeExcelhas encountered a problem and needs to close. *We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft OfficeExcel, it is opening the blankexcelform.

what is wrong with this?

Thanks



"Ron de Bruin" wrote:
Hi ss


Try this first


Run Office Diagnostics.
Office ButtonExcelOptions...Resources


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Hi,


I am usingExcel2007.
Each time I CloseExcelI get an error box (Microsoft OfficeExcelhas
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restartExcel. What can this problem be?


Thanks- Hide quoted text -


- Show quoted text -


This means your file is damaged. You can try a popular Excel file
recovery tool called Advanced Excel Repair to repair your Excel file.
It is a powerful tool to repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Maybe the information will help.

Alan
  #19   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Error with closing the Excel file

On Jan 31, 1:56*am, ss wrote:
Actually, this file is an Excel Template. *It contains some 6 excel sheets
with in it.
It was created using Excel 2003.
Now, I have converted this template to Macro enabled excel template. (.XSLT)
in 2007.

we have some 10 users for this file. All of them are getting that error when
they are closing the form and I am sure that this is the only file that we
are facing this problem.



"Ron de Bruin" wrote:
Is it one workbook that have this problem ?


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Ron,


I tried repair of office.
Still it is giving me the same error while closing the form.


can you suggest me any thing else to try?


TIA
ss


"ss" wrote:


How can I do a repair of Office?
Is there any tool within Office 2007 for this?


Thanks


"Ron de Bruin" wrote:


Try a repair of Office


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Yes,


I did as said by you. But it does nothing.
I have opened the form in safe mode.
Still it is giving the same error.


"ss" wrote:


Ron,


Yes, I ran the Office diagnostics, I showed me the message that " one
problem has repaired by the Office diagnostics"


but, even after that also, It is giving me the same error.


Microsoft Office Excel has encountered a problem and needs to close. *We are
sorry for the inconvenience.
Unless I uncheck the Restat Microsoft Office Excel, it is opening the blank
excel form.


what is wrong with this?


Thanks


"Ron de Bruin" wrote:


Hi ss


Try this first


Run Office Diagnostics.
Office ButtonExcel Options...Resources


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ss" wrote in ...
Hi,


I am using Excel 2007.
Each time I Close Excel I get an error box (Microsoft Office Excel has
encountered a problem and needs to close. We are sorry for the
inconvenience) and if I don't un-check "restart microsof office" it will
restart Excel. What can this problem be?


Thanks- Hide quoted text -


- Show quoted text -


Hi,

Did this problem damage your excel files? If so, I think you can try a
popular Excel file recovery tool called Advanced Excel Repair to
repair your Excel file. It is a powerful tool to repair corrupt or
damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing Excel user form generates error Ken Warthen Excel Discussion (Misc queries) 0 October 10th 07 08:30 PM
Error while opening/Closing excel Hari Excel Discussion (Misc queries) 0 November 17th 06 06:55 AM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
Error report closing excel Maz Excel Discussion (Misc queries) 0 September 30th 05 11:26 PM
Unexpected error message on closing an Excel file KG Excel Discussion (Misc queries) 1 March 21st 05 02:39 PM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"