ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting Issue (https://www.excelbanter.com/excel-discussion-misc-queries/96586-conditional-formatting-issue.html)

afsoares

Conditional Formatting Issue
 
Hi guys,
I have a problem with my excel 2000 Std, everytime then I click in the
Conditional Formatting button Excel shows the win message "Excel has
encountered a problem and needs to close".
I changed the current version and installed other one but the problem
continuous.
Do you know how to fix it?
Thanks!!


JLatham

Conditional Formatting Issue
 
If this is an empty cell and you are just starting the conditional formatting
process, then it is either a corrupt workbook or bad/corrupted Excel.

Test in another workbook and see if you get the same error. If not, then
the other workbook is probably corrupted.

If it doesn't work no matter what workbook you try, then probably Excel
installation has gotten corrupted - try a repair install of Office or Excel
(if stand alone) and if that fails, then uninstall and reinstall.

"afsoares" wrote:

Hi guys,
I have a problem with my excel 2000 Std, everytime then I click in the
Conditional Formatting button Excel shows the win message "Excel has
encountered a problem and needs to close".
I changed the current version and installed other one but the problem
continuous.
Do you know how to fix it?
Thanks!!



afsoares

Conditional Formatting Issue
 
Hi JLatham, thanks for your reply.
I uninstalled MS Office and cleaned all reg files but it continuous. I
think that format the desktop is the best solution but I can't do it.
It'll spend time. Do you know some free software that can help me?
Thanks in advance.

JLatham wrote:
If this is an empty cell and you are just starting the conditional formatting
process, then it is either a corrupt workbook or bad/corrupted Excel.

Test in another workbook and see if you get the same error. If not, then
the other workbook is probably corrupted.

If it doesn't work no matter what workbook you try, then probably Excel
installation has gotten corrupted - try a repair install of Office or Excel
(if stand alone) and if that fails, then uninstall and reinstall.

"afsoares" wrote:

Hi guys,
I have a problem with my excel 2000 Std, everytime then I click in the
Conditional Formatting button Excel shows the win message "Excel has
encountered a problem and needs to close".
I changed the current version and installed other one but the problem
continuous.
Do you know how to fix it?
Thanks!!




JLatham

Conditional Formatting Issue
 
Don't know of any software that will cure you problem. I'm not sure what you
mean by "format the desktop" - unless you mean format the desktop computer's
hard drive. That's a bit drastic as it would mean reinstalling everything
from the OS on up.

This is almost as much work but might help. Often uninstall does not remove
everything, either from the registry or from the hard drive. I see you
already went into the registry after the last cleanup. Once again uninstall
and clean the registry and then find the MSO folder in Program Files - it's
normally
c:\Program Files\Microsoft Office
and delete everything in it. Almost as drastic as scrubbing the hard drive,
but not quite. You'll lose all your personalized settings and have to
reactivate the software when you reinstall.

Wish I could offer you a better solution. You might search around the
internet via MSN, Google or Yahoo or your search engine of choice for
something like "conditional format error" or "conditional format fails" and
see if anything useful turns up.

"afsoares" wrote:

Hi JLatham, thanks for your reply.
I uninstalled MS Office and cleaned all reg files but it continuous. I
think that format the desktop is the best solution but I can't do it.
It'll spend time. Do you know some free software that can help me?
Thanks in advance.

JLatham wrote:
If this is an empty cell and you are just starting the conditional formatting
process, then it is either a corrupt workbook or bad/corrupted Excel.

Test in another workbook and see if you get the same error. If not, then
the other workbook is probably corrupted.

If it doesn't work no matter what workbook you try, then probably Excel
installation has gotten corrupted - try a repair install of Office or Excel
(if stand alone) and if that fails, then uninstall and reinstall.

"afsoares" wrote:

Hi guys,
I have a problem with my excel 2000 Std, everytime then I click in the
Conditional Formatting button Excel shows the win message "Excel has
encountered a problem and needs to close".
I changed the current version and installed other one but the problem
continuous.
Do you know how to fix it?
Thanks!!






All times are GMT +1. The time now is 07:23 AM.

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