| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data copy locks cell in worksheet
I'm using a protected worksheet (Excel 2003) that allows people to update
selected cells. Direct data entry by typing works fine. However, when data is copied into an unlocked cell from Word, SharePoint, or other Excel files, the data posts and the cell becomes locked. Cells with pasted data cannot be accessed by anyone other than the worksheet owner with the password. How can users copy data into unlocked cells in a protected worksheet without the destination cell becoming locked? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data copy locks cell in worksheet
Maybe you could train them to paste directly into the formulabar--or use
edit|Paste special Text. M. Nelson wrote: I'm using a protected worksheet (Excel 2003) that allows people to update selected cells. Direct data entry by typing works fine. However, when data is copied into an unlocked cell from Word, SharePoint, or other Excel files, the data posts and the cell becomes locked. Cells with pasted data cannot be accessed by anyone other than the worksheet owner with the password. How can users copy data into unlocked cells in a protected worksheet without the destination cell becoming locked? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data copy locks cell in worksheet
Thanks. The formula bar works.
Paste Special - Text does not. The cell becomes locked. "Dave Peterson" wrote: Maybe you could train them to paste directly into the formulabar--or use edit|Paste special Text. M. Nelson wrote: I'm using a protected worksheet (Excel 2003) that allows people to update selected cells. Direct data entry by typing works fine. However, when data is copied into an unlocked cell from Word, SharePoint, or other Excel files, the data posts and the cell becomes locked. Cells with pasted data cannot be accessed by anyone other than the worksheet owner with the password. How can users copy data into unlocked cells in a protected worksheet without the destination cell becoming locked? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data copy locks cell in worksheet
Both worked ok for me. But at least you have one suggestion that works for you.
M. Nelson wrote: Thanks. The formula bar works. Paste Special - Text does not. The cell becomes locked. "Dave Peterson" wrote: Maybe you could train them to paste directly into the formulabar--or use edit|Paste special Text. M. Nelson wrote: I'm using a protected worksheet (Excel 2003) that allows people to update selected cells. Direct data entry by typing works fine. However, when data is copied into an unlocked cell from Word, SharePoint, or other Excel files, the data posts and the cell becomes locked. Cells with pasted data cannot be accessed by anyone other than the worksheet owner with the password. How can users copy data into unlocked cells in a protected worksheet without the destination cell becoming locked? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
| Excel data query locks source file | Excel Discussion (Misc queries) | |||
| excel locks up after selecting a cell | Excel Discussion (Misc queries) | |||
Linear Mode
