Format Cell Problem
 

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe has
generated errors and had to be closed. It doesn't matter if you do it from
the top menu or if you right click on the mouse. We have tried the repair
option as well as uninstalling and reinstalling excel. Nothing has worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe has
generated errors and had to be closed. It doesn't matter if you do it from
the top menu or if you right click on the mouse. We have tried the repair
option as well as uninstalling and reinstalling excel. Nothing has worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe has
generated errors and had to be closed. It doesn't matter if you do it from
the top menu or if you right click on the mouse. We have tried the repair
option as well as uninstalling and reinstalling excel. Nothing has worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe has
generated errors and had to be closed. It doesn't matter if you do it from
the top menu or if you right click on the mouse. We have tried the repair
option as well as uninstalling and reinstalling excel. Nothing has worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Thanks Gord. I tried the search on the offending pc and it does not locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe has
generated errors and had to be closed. It doesn't matter if you do it from
the top menu or if you right click on the mouse. We have tried the repair
option as well as uninstalling and reinstalling excel. Nothing has worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

This computer is running Windows 2000. I do not see a hidden file option. I
did this search on another of our computers running the same version of
Windows and it did come up with 4 files by the name of Excel.XLB when I did
the search. That computer doesn't have any issues with Excel.



"Peo Sjoblom" wrote:

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Your *.xlb file will be named Excel9.xlb and is usually found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord

On Wed, 26 Sep 2007 11:04:03 -0700, Polk Nursery Co., Inc.
wrote:

This computer is running Windows 2000. I do not see a hidden file option. I
did this search on another of our computers running the same version of
Windows and it did come up with 4 files by the name of Excel.XLB when I did
the search. That computer doesn't have any issues with Excel.



"Peo Sjoblom" wrote:

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Still no luck finding the file on that computer. Could this be part of the
problem?


"Gord Dibben" wrote:

Your *.xlb file will be named Excel9.xlb and is usually found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord

On Wed, 26 Sep 2007 11:04:03 -0700, Polk Nursery Co., Inc.
wrote:

This computer is running Windows 2000. I do not see a hidden file option. I
did this search on another of our computers running the same version of
Windows and it did come up with 4 files by the name of Excel.XLB when I did
the search. That computer doesn't have any issues with Excel.



"Peo Sjoblom" wrote:

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Excel will always create a *.XLB file if none exists.

It is the default file where Toolbar and menus setups are stored.

If you delete it, Excel will build a new one.

You "must" have one on your computer if you open and close Excel even once.

I have never used Windows 2000 but when you open My Computer and go to
ToolsFolder OptionsView you should find an option button for "show hidden
files and folders"


Gord

On Wed, 26 Sep 2007 12:04:02 -0700, Polk Nursery Co., Inc.
wrote:

Still no luck finding the file on that computer. Could this be part of the
problem?


"Gord Dibben" wrote:

Your *.xlb file will be named Excel9.xlb and is usually found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord

On Wed, 26 Sep 2007 11:04:03 -0700, Polk Nursery Co., Inc.
wrote:

This computer is running Windows 2000. I do not see a hidden file option. I
did this search on another of our computers running the same version of
Windows and it did come up with 4 files by the name of Excel.XLB when I did
the search. That computer doesn't have any issues with Excel.



"Peo Sjoblom" wrote:

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

Found the file. Tried the renaming. Still got the error when I opened Excel
and asked for it to format.

Mindy

"Gord Dibben" wrote:

Excel will always create a *.XLB file if none exists.

It is the default file where Toolbar and menus setups are stored.

If you delete it, Excel will build a new one.

You "must" have one on your computer if you open and close Excel even once.

I have never used Windows 2000 but when you open My Computer and go to
ToolsFolder OptionsView you should find an option button for "show hidden
files and folders"


Gord

On Wed, 26 Sep 2007 12:04:02 -0700, Polk Nursery Co., Inc.
wrote:

Still no luck finding the file on that computer. Could this be part of the
problem?


"Gord Dibben" wrote:

Your *.xlb file will be named Excel9.xlb and is usually found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord

On Wed, 26 Sep 2007 11:04:03 -0700, Polk Nursery Co., Inc.
wrote:

This computer is running Windows 2000. I do not see a hidden file option. I
did this search on another of our computers running the same version of
Windows and it did come up with 4 files by the name of Excel.XLB when I did
the search. That computer doesn't have any issues with Excel.



"Peo Sjoblom" wrote:

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.

Format Cell Problem
 

You are running Windows 2000.

Which version of Excel?

If 2000 or earlier have a look at this KB Article

XL: Illegal Operation Error When You Attempt to Format Cells

http://support.microsoft.com/kb/285347/en-us


Gord

On Thu, 27 Sep 2007 05:32:01 -0700, Polk Nursery Co., Inc.
wrote:

Found the file. Tried the renaming. Still got the error when I opened Excel
and asked for it to format.

Mindy

"Gord Dibben" wrote:

Excel will always create a *.XLB file if none exists.

It is the default file where Toolbar and menus setups are stored.

If you delete it, Excel will build a new one.

You "must" have one on your computer if you open and close Excel even once.

I have never used Windows 2000 but when you open My Computer and go to
ToolsFolder OptionsView you should find an option button for "show hidden
files and folders"


Gord

On Wed, 26 Sep 2007 12:04:02 -0700, Polk Nursery Co., Inc.
wrote:

Still no luck finding the file on that computer. Could this be part of the
problem?


"Gord Dibben" wrote:

Your *.xlb file will be named Excel9.xlb and is usually found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel


Gord

On Wed, 26 Sep 2007 11:04:03 -0700, Polk Nursery Co., Inc.
wrote:

This computer is running Windows 2000. I do not see a hidden file option. I
did this search on another of our computers running the same version of
Windows and it did come up with 4 files by the name of Excel.XLB when I did
the search. That computer doesn't have any issues with Excel.



"Peo Sjoblom" wrote:

It's a hidden file, make sure you have hidden files included in the search
(more advanced options in windows xp)


--


Regards,


Peo Sjoblom


"Polk Nursery Co., Inc." wrote
in message ...
Thanks Gord. I tried the search on the offending pc and it does not
locate a
file with that name.

Mindy

"Gord Dibben" wrote:

Try this trick which most times clears up the problem.

Close Excel, do a file search for *.XLB

Rename it to *.XLBOLD......ignore the warning.

Re-open Excel and a workbook.

Does the problem still exist?


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 06:46:02 -0700, Polk Nursery Co., Inc.
wrote:

I just tried that and it still gives me the error when I try to select
Formatcells.

Any other thoughts?

Mindy

"Gary''s Student" wrote:

Try this:
1. open a fresh, clean workbook
2. select all the cells
3. Edit Clear Formats

Then try to set a format
--
Gary''s Student - gsnu200745


"Polk Nursery Co., Inc." wrote:

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe
has
generated errors and had to be closed. It doesn't matter if you do
it from
the top menu or if you right click on the mouse. We have tried the
repair
option as well as uninstalling and reinstalling excel. Nothing has
worked so
far. Any suggestions on how to solve this problem.

Thanks.