Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Copy Custom Styles in Excel 2013
How to Merge Changes from Different Excel 2013 Users
How to Embed and Link Data from Excel 2013 into Word 2013

How to Protect Your Excel Workbook when Saving the File

Step 7 of 7
Next Slideshow
Next Slideshow

Click the Yes button if the alert dialog box that asks whether you want to replace the existing file appears.

Select the Read-Only Recommended check box in the General Options dialog box instead of assigning a password for editing the workbook in the Password to Modify text box when you never want the user to be able to make and save changes in the same workbook file. When Excel marks a file as read-only, the user must save any modifications in a different file using the Save As command.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Assign Graphic Images as Excel Worksheet Backgrounds
Assign a Password to Open from the Excel Info Screen
How to Enable Excel Cell Range Editing by Certain Users
How to Save Changes to Customized Templates in Excel 2013
How to Download a Spreadsheet Template in Excel 2013
Advertisement

Inside Dummies.com