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
---------------
Jacob Skaria


"Denise Draper" wrote:

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.

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" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Denise Draper" wrote:

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.

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
ClickFormatCellsChange 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
---------------
Jacob Skaria


"Denise Draper" wrote:

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" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Denise Draper" wrote:

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.