Can't edit Excel doc (Compatability Mode)

  • Thread starter Thread starter Christian
  • Start date Start date
C

Christian

I have an Excel document I just received. It opens fine, but I cannot click
on any field to edit it, though I should be able to. The person who created
the document also has the same problem.

It does say "Compatability Mode" at the top, but not sure why. I can save
the file as different versions, .xls, .xlsx. Both versions say
"Compatability Mode"

Using Excel 2007.


Appreciate the help!

Christian
 
hi Christian

Maybe the sheet is protected with the setting not to select locked cells.
If all cells are locked then you can't select cells

If you insert a new sheet with Shift F11 can you edit cells then ?
 
You put me in the right direction... I was able to creat a new sheet.
Then, I happened to go to View and noticed that it was set to Page Layout.
Changing it to Normal let me edit all fields. Changing back to Page Layout
also let me edit.

Thanks!
 
Back
Top