Excel has a few security features that come in handy when you are using, and especially sharing, data in a workbook. You can choose what personal information Excel stores with your files and adjust security settings as well. Use the following articles to understand and utilize security in Excel.

Tips, Tricks, and Answers

The following articles are available for the 'Security' topic. Click the article''s title (shown in bold) to see the associated article.

   Automatically Enabling Macros for Specific Workbooks
On your system you may have workbooks that contain macros you know are safe to use. Microsoft provides two things you can do with such workbooks that will cause those workbooks to load without impediment. This tip looks at both trusted locations and provides a link to additional information about digital signatures.

   Disabled Macros
Do your macros seem to be disabled on your new machine? It could be because of the security settings in Excel. Here's where they are located and how to change them.

   Limiting Where a Workbook is Used
Want to limit who can use your workbook and on what system? Locking down a workbook can be trickier than you might imagine.

   Removing Personal Information
As you create and work on your workbooks, Excel can include sensitive personal information with the data. If you want to get rid of this information, you can do so by using the tools described in this tip.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.