Cell Format Not Available - Excel 2003

J

jpidgen

We have an old spreadsheet that was originally created by Excel 2000.
It is a complex workbook with many formulas. It does not have locked
cells, nor is it protected.

The problem, is that a bunch of cells will not allow for formatting.
We can't figure out why. If one right clicks while on the cell, the
short-cut menu appears, but if you click on "Format Cells" nothing
happens (it doesn't take you to the next menu). The same happens if
you go through the toolbar and try to click FORMAT then CELLS.

I've searched a couple of databases and I can't find any reference to
this type of problem. I'm hoping someone here might be able to help.

Thanks!
 
M

millsy

Are you sure that the creator of the worksheet did not protect the
formats? Try Tools>Protection>Protect Sheet and see if any of the
format protecting options are ticked.
 
J

jpidgen

We're triple sure that the worksheet is not protected. That's why this
is so frustrating. The strange thing, is that not ALL the cells in
this worksheet act this way. There are areas that will allow
formatting and other areas that will not.
 
Top