How do I make an Excel document read only or protect it?

Question

I have some Excel documents to send to other parties outside my office. I want to set it so they can't modify any of the data, but they can filter it. How do I do that? I've been trying but every attempt at protecting the document can be undone by the person I'm sending it to.

Answer 1

right-click on the file's icon
select properties
click to render "read only"

The user can read it and edit, but must save the file to a new name -- if this suits your purpose.

Answer 2

Make Excel File Read Only

Answer 3

Make Excel Read Only

Answer 4

This Site Might Help You.

RE:
How do I make an Excel document read only or protect it?
I have some Excel documents to send to other parties outside my office. I want to set it so they can't modify any of the data, but they can filter it. How do I do that? I've been trying but every attempt at protecting the document can be undone by the person I'm sending it to.

Answer 5

Right Click your Excel files and go to Properties and Set to Read only and than save the File

Answer 6

Under Tools--protect --WORKBOOK, not just the sheet

Remove protection or protect,from an entire workbook
On the Tools menu, point to Protection, and then click Unprotect Workbook. or protect
If prompted, enter the password assigned when the workbook was protected. Passwords are case sensitive. You must type the password exactly as it was created, including uppercase and lowercase letters.

Answer 7

- File >> Save As
- In the Save As box, Click "Tools" (Bottom right hand side)
- Select "General Options..." from the drop down
- Set password for either to Open it or just to modify it (i.e. anyone can open as read-only, but need password to modify) or for both then check both the options & also check on Read only recommended box.

I hope this will help.

Answer 8

Tools menu then protection

Answer 9

For the best answers, search on this site https://shorturl.im/9rzPZ

I am assuming that you are using excel 2000 *To password-protect a workbook, open the file menu *choose "save as" *click on the arrow on the "tools" button in the dialog box's toolbar *choose "general options" *in the save options dialog box, key in your password at the "password to open" prompt *it will ask you to re-key your password for confirmation *click "ok" *choose "save" in the "save as" dialog box. a message box will appear asking if you want to replace the existing file named (whatever your file is called)...Click yes