Save a workbook as read-only or remove read-only status

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

In Excel 2003, you can control the ability to read or write to a workbook file by changing a setting for the file while you have it open in Excel or by changing the a property of the file by using Windows Explorer.

What do you want to do?


Use Save As to set an option that recommends that a file be opened read-only when it is opened

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. With the file open in Excel, 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.

Make a workbook file read-only

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

Make a workbook file read/write

  1. Make sure that the file is not open in Excel.
  2. On the Windows Start menu, point to Programs, point to Accessories, and then click Windows Explorer.
  3. In the Exploring window, open the drive or folder that contains the file.
  4. Click the file name.
  5. On the File menu, click Properties.
  6. Click the General tab.
  7. Clear the Read-only check box.
 
 
Applies to:
Excel 2003