Get our new Windows 7 eBook (PDF) for $7 with 70+ Tips. Download Now!
Prompt To Open A Spreadsheet As Read-Only In Excel 2007
- 2
- Add a Comment
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:
- Within Excel, click the Microsoft Office Button and the click Save As.
- Click Tools and then click General Options.
- Click the Read-only recommended option.
- Click OK.
- Click Save.
- If prompted, click Yes to update the existing file with the new read-only setting.
- Business Data Analysis With Excel.
- Tutorials - Photoshop,Dreamweaver,VB.NET.
- How To Land A Pharmaceutical Sales Job.
- Power Station Financial Models.
- 101 Secrets Of A Microsoft Excel Addict.
- Store Of Manual Of Computation ManualShop.
- eBay(R) Excel Spreadsheets.
- Training Resources For Microsoft Excel.
- Learn Microsoft Office Via Online Elearning Courses.
- 75% Of $200! $150 Payout! Easy Sell B/c Were A Product And Service!
2 Comments
Gerry Vrbensky
December 16th, 2008
at 5:51am
If you save the file as read only, anybody could just change the attribute. Why not simply password protect the file?
Dan Bromberg
December 16th, 2008
at 10:04pm
In my Office Excel ‘07 when I click SAVE AS there is no Tools option !?!