How do I save an Excel sheet as read only?

How do I save an Excel sheet as read only?

Save as read only

1. Click the Microsoft Office Button. , and then click Save or Save As if you have previously saved the document.
2. Click Tools.
3. Click General Options.
4. Click the Read-only recommended check box.
5. Click OK.
6. Save the document.

How do you unlock an Excel spreadsheet for editing?

Unprotect an Excel worksheet

1. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
2. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box, and click OK.

How do you password protect an Excel File for editing?

Require a password to open or modify a workbook

1. Open the sheet or workbook that you want to protect.
2. On the Review tab, click Protect Sheet or Protect Workbook.
3. In the Password box, type a password, and in the Verify box, type the password again.
4. Choose any other protection options you want and click OK.
5. Click Save.

How do I make an Excel file read only without password?

Read-only Workbook

1. Click on the Tools button and click General Options.
2. In the Password to modify box, enter a password and click OK.
3. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don’t enter a password and check Read-only recommended.

How do I enable read only in Excel?

Prompt to open a workbook as read-only

1. Open the workbook you want to protect.
2. Click the File menu, and then click Passwords.
3. In the File Passwords dialog box, select the Read-only recommended check box, and click OK.
4. Close the workbook.

How to publish a workbook to a SharePoint site in Excel?

This article shows you how to publish a workbook from Excel for Windows and does not cover connecting a workbook or workbook data to an Excel Web Access Web Part on a SharePoint page. When you publish a workbook to a SharePoint site, the entire workbook is saved to SharePoint.

How to publish or Unpublish a file SharePoint document?

Click the ellipses ( ), click the ellipses again ( ), and then click Publish a major version. Hover over the title of the document with your mouse, click the drop-down arrow, and click Publish a major version. The Publish Major Version dialog box opens. Enter a comment in the Comments field and then click OK.

Do you need a SharePoint Server to use Excel?

You must be using Excel and SharePoint Server 2013. Excel Services must be configured to include a trusted data connections library and a trusted document library. Ideally, you’ll have a Business Intelligence Center site configured that you can use for your data connections and workbooks.

How to save a SharePoint file in Excel?

Click the File tab, click Save As, and then click SharePoint. If you see your SharePoint folder under Current, Recent, or Older, click the folder you want. The Save As dialog box appears.