Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected/Unprotected Cells
Weve generated an updated requisition form, using Excel 2007. Weve
protected some cells, but left others open for data input. When someone tries to copy data from an (older) existing form into the new requisition, the results take on the protected format, and they cant be edited or removed. I can use a Paste Special and select either Text or Csv format, to get the results to appear normally & be editable, but a lot of people are going to start out with the straight Paste function & may become frustrated. Do you have any ideas as to whats going on? Might this be an Excel version x versus Excel 2007 thing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a row containing protected & unprotected cells be copied? | Excel Worksheet Functions | |||
Delete unprotected cells in protected worksheet | Excel Worksheet Functions | |||
Protected worksheet with unprotected cells i.c.w. remarks | Excel Worksheet Functions | |||
Can some cells remain unprotected in a protected spreadsheet ? | Excel Discussion (Misc queries) | |||
Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) |