| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent someone copying information into a cell in excel
I am reciving #REF errors from a calculation when a user of the excel sheet
copies and paste information over from a website... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I prevent someone copying information into a cell in excel
right click on the cell, Format Cells / Protection / Locked
then- Tools / Protection / Protect sheet and give it a password "Frank" wrote: I am reciving #REF errors from a calculation when a user of the excel sheet copies and paste information over from a website... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I prevent someone copying information into a cell in ex
I need these cells to be unlocked for data entry. We are entering in account
numbers in this field. The crew is supposed to have this information at hand but if it is missing the they look it up on a website. The error occurs when they copy the number and paste it into the cell. This will change the sheet (I'm not sure how it does it) and screws up simple formulas across the worksheet. Any help to prevent this would be greatly apprecated! "dlw" wrote: right click on the cell, Format Cells / Protection / Locked then- Tools / Protection / Protect sheet and give it a password "Frank" wrote: I am reciving #REF errors from a calculation when a user of the excel sheet copies and paste information over from a website... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying information from one cell to another without modifying it. | New Users to Excel | |||
| prevent changes to cell references when copying and pasting | Excel Discussion (Misc queries) | |||
| What formula do I use for copying cell information between workboo | Excel Worksheet Functions | |||
| Copying Cell information | Excel Worksheet Functions | |||
| Comparing and copying information from one cell to another | Excel Worksheet Functions | |||
Linear Mode
