Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't edit Excel doc (Compatability Mode)
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't edit Excel doc (Compatability Mode)
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't edit Excel doc (Compatability Mode)
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
installed sp1 and now only compatability mode works | Excel Discussion (Misc queries) | |||
Compatability Mode Not Responding | Setting up and Configuration of Excel | |||
Track changes in excel 2007 compatability mode | Excel Discussion (Misc queries) | |||
Compatability mode | Excel Discussion (Misc queries) | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |