Can't edit Excel doc (Compatability Mode)


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
 
Ad

Advertisements

R

Ron de Bruin

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 ?
 
C

Christian

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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top