new cells in excel default to locked?

  • Thread starter Thread starter Denise Draper
  • Start date Start date
D

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.
 
By default all cells in excel are locked., Locked cells have no use until we
protect the Worksheet..

If this post helps click Yes
 
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.
 
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
 
Back
Top