ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error with closing the Excel file (https://www.excelbanter.com/excel-discussion-misc-queries/174018-error-closing-excel-file.html)

SS

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



Ron de Bruin

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



SS

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




Ron de Bruin

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




SS

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




Ron de Bruin

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




SS

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





Ron de Bruin

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





SS

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





Ron de Bruin

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





SS

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






[email protected]

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

Ron de Bruin

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






SS

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


Ron de Bruin

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


RobN[_2_]

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




Ron de Bruin

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




Alan[_10_]

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

Alan[_10_]

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


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com