How do I prevent someone copying information into a cell in excel

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I am reciving #REF errors from a calculation when a user of the excel sheet
copies and paste information over from a website...
 
right click on the cell, Format Cells / Protection / Locked
then- Tools / Protection / Protect sheet and give it a password
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Excel Worksheet 1
Cell in new sheet should always refer to defined cell in another s 8
copy doument names from a file into excel 6
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Why is the first copy and paste into Excel 2007 getting slower? 8
Copy/Paste from Wordto Excel changes formatting - Office 2007 1
Spreadsheet macro stopped working! 5
Blank cells 1

Back
Top