View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Can't edit Excel doc (Compatability Mode)

Thanks for the feedback

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Christian" wrote in message ...
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!


"Ron de Bruin" wrote in message
...
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 ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Christian" wrote in message
...
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