Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Set or clear read-only status for a workbook file
 

ShowRecommend that a file be opened read-only

When you set this option, users get a read-only (read-only: A setting that allows a file to be read or copied but not changed or saved.) recommendation when they open the file. This does not prevent users from opening the file as read-write so that they can edit and save changes.

  1. On the File menu, click Save As.
  2. On the Tools menu in the Save As dialog box, click General Options.
  3. Select the Read-only recommended check box, and then click OK.
  4. Click Save.
  5. If prompted, click Yes to replace the existing workbook.

ShowMake a workbook file read-only

  1. On the Windows Start menu, point to Programs, point to Accessories, and then click Windows Explorer.
  2. In the Exploring window, open the drive or folder that contains the file.
  3. Click the file name.
  4. On the File menu, click Properties.
  5. Click the General tab.
  6. Select the Read-only check box.

ShowMake a workbook file read-write

  1. On the Windows Start menu, point to Programs, point to Accessories, and then click Windows Explorer.
  2. In the Exploring window, open the drive or folder that contains the file.
  3. Click the file name.
  4. On the File menu, click Properties.
  5. Click the General tab.
  6. Clear the Read-only check box.
advertisement