There will be a button that says Data Analysis and that takes you to all of the Analysis ToolPak features. There you can get the link bringing you to Help. Excel Options is on the left side of the Backstage View, at the bottom.
So first off, let’s look at how we access the Excel Options. If you have the Analysis ToolPak already installed, you will find it on the Data tab all the way to the right. If you need to make Excel 2013 suitable for your work, you can do that by setting this up. It helps track changes to Excel files and gives a clear picture of who, how and when modified the document.
That button takes you to all of the new statistical analysis feature that you can now use in Excel. How to enable Version Control in Excel and start tracking changes XLTools Version Control add-in for Excel workbooks is a revision control, or a source control tool. Now, go to the Data tab and look all the way to the right and you will see the new button Data Analysis. In the window that opens, select the Analysis ToolPak option and any other options you want.Once done try to open any Excel file and verify the status. Save the document to another location to be able to work on it effectively. The document is now opened as read-only with some content disabled. Select Open selected file types in Protected View and allow editing. The message bar will appear along the top of the document and offer you the chance to enable editing. In the Trust Center, click File Block Settings. Click Trust Center and then click Trust Center Settings. Click it and make sure it says Excel Add-ins and then click the Go. Click on ‘Options’ the Options dialog box appears. Look to the bottom of the window for a drop-down menu that says Manage: next to it.Click the Add-Ins option from the left side of the window that opens.Click Options from the left side of the menu that appears ( Excel Options for Excel 2007).Click the File button (Microsoft Office Button for Excel 2007).
Protected View is one of the most common situations you will meet if you download files from the Internet. This is an add-in program that comes with Excel and allows you to use powerful statistical and engineering analysis features. Part 2: Other 4 Ways to Enable Editing in Excel Read Only. How to enable the Analysis ToolPak in Excel.