E-Mail:

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.

What Do You Think?

 

Want to Start a Blog Here for Free?

Are you an expert in one subject or another? If your goal is to help others and dispense your hard-earned information back to the community, get involved in our community site today! You can write about anything - no matter the topic. Exceptional candidates will be offered the chance to contribute to (and generate revenue from) the main Lockergnome site. Join us today!

Favorite, Freeware - Dec 2, 2008

ContestMachine

Resource - Dec 2, 2008

Group Tour Magazine

Diana's Tips - Nov 26, 2008

Change Your Account Picture In Vista

69 queries / 0.645 seconds.