If you don't see the Inquire tab on the ribbon, you need to install the Inquire add-in. The Inquire tab is visible after you enable the Inquire add-in, which is available in Excel if Microsoft Office Professional Plus 2013 is installed on your computer. You do this by using passwords that you can have Excel store on your computer. If you're using the commands on the Inquire tab in Excel to analyze or compare workbooks that are password-protected, you can avoid having to type the password each time those files are opened. Want to see what version of Office you're using? Inquire is only available in the Office Professional Plus and Microsoft 365 Apps for enterprise editions. I’ve found the Inquire add-in has a couple nice features that i can definitely see myself using in our increasingly Excel centric world we live in.Important: This feature isn’t available in Office on a Windows RT PC. This is the standard Excel Help that will walk you through what the add-in does. If you are using the Inquire add-in for analyzing workbooks that are password protected you must add the workbook password to the Password Manager. You can test it out by putting a background color on a couple irrelevant cells and then run the tool. This can actually help increase the performance and file size of workbook that have become bloated with this kind of leftover formatting. If you’ve developed an Excel workbook that’s gotten out hand with how large it is and how much logic is built in use the Clean Excess Cell Formatting tool to remove extra formatting on cells that you may not be aware of. Miscellaneous Clean Excess Cell Formatting You need to have two workbooks open in Excel to run this command.Īny differences that the compare tool finds color coded by content type in a grid view. The Compare Files command lets you see the differences, cell by cell, between two workbooks. These are often dependencies are often displayed because a cell is referenced in a formula. The Worksheet Relationship tool works exactly the same as the Workbook Relationship but now visualizing dependencies at the sheet level.Īgain the Cell Relationship tool is very similar but it only shows relationships of cells that you have highlighted prior to click on the command. Trying to untangle that mess can be very difficult and this tool visualizes those dependencies. This can be especially helpful when you have dozens of cell references to an external workbook. The Workbook Relationship tool shows links between multiple workbooks that you may have. See here for more details on how to do a Very hidden sheet. This is simple another way of hiding sheets through VBA. One odd thing here that a lot of people notice a workbook structure property called “Very hidden sheets”. The Workbook Analysis tool is used for analyzing details of a workbook for reporting on the things like the workbook structure, formulas, cells, ranges, and warnings. What does it do? Report Workbook Analysis Let’s take a look at what this new add-in has given us. Once you have enabled the add-in the INQUIRE tab will appear in the increasingly crowded Office ribbon. Then Select COM Add-ins from the Manage dropdown and click GoĬheck off Inquire from the Add-Ins available list then click OK. The Inquire add-in is already installed with Excel 2013 you simply need to enable it by going to File –> Options –> Add-Ins. If you are using Office Professional Plus, the Inquire add-in comes installed with Excel you simply need to enable it. Let’s take some time to review how to enable the add-in and then how to use it. The Inquire Add-in for Excel 2013 helps you analyze and review your workbooks for things like relationships, invalid formulas, and to compare.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |