new cells in excel default to locked?

[Denise Draper]

This just started happening to me: new columns added to an excel workbook
are locked (the checkbox on the "Protection" tab of Format Cells is checked).
I tried creating an entirely new workbook, and all the cells in it were
locked.
What could be happening?

Helpful information: I just installed windows 7 RC, and along with it
Office 2007 Enterprise Edition SP2 (build 6425). I suspect that the problem
is related. I did not have this problem previously, when I was using Office
2007 SP2 with Vista.

 

[Jacob Skaria]

By default all cells in excel are locked., Locked cells have no use until we
protect the Worksheet..

If this post helps click Yes

 

[Denise Draper]

Thank you --- that makes sense. But it shows that I didn't assess my
problem correctly. What is happening is that when I enter a formula into a
cell, it does not get evaluated. The formula entry works (including
intellisense for functions, etc.), but when I hit <enter>, the formula is
left in the cell in plain text rather than evaluated.

This happens only with new cells in the workbook --- if I enter a formula
into a pre-existing cell, it behaves normally.

I was trying to figure out what the problem might be and found the "locked"
checkbox and thought that had something to do with it.

 

[Jacob Skaria]

Check out the cell format of the new column. The new columns inserted may be
near to a column with 'Text format'. Select the column. Right
Click>FormatCells>Change the format to General and then enter a new formula
and try..For existing formula; edit (f2) and Enter

If this post helps click Yes