Prompt To Open A Spreadsheet As Read-Only In Excel 2007

If you share a spreadsheet with other users, you could be concerned about them making unwanted modifications to it. Excel has a few different features you can use to prevent this from happening.

One way you can prevent other from modifying a file is by having it open as read-only. When a reviewer opens the Excel file, a prompt will appear recommending that the file be opened as read-only. If it is opened in read-only mode, the changes can only be saved by giving the file a new name.

To recommend read-only mode in Excel 2007:

  1. Within Excel, click the Microsoft Office Button and the click Save As.
  2. Click Tools and then click General Options.
  3. Click the Read-only recommended option.
  4. Click OK.
  5. Click Save.
  6. If prompted, click Yes to update the existing file with the new read-only setting.

[rsslist:http://shop.tagjag.com/products/excel]

Article Written by

  • http://www.stgeorgetennis.ca Gerry Vrbensky

    If you save the file as read only, anybody could just change the attribute. Why not simply password protect the file?

  • Dan Bromberg

    In my Office Excel ’07 when I click SAVE AS there is no Tools option !?!

  • BigDaddy

    Thanks…your suggestion worked like a charm