ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protected/Unprotected Cells (https://www.excelbanter.com/excel-discussion-misc-queries/239360-protected-unprotected-cells.html)

LtGator

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?


All times are GMT +1. The time now is 07:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com