![]() ![]() This can be used to gain an even deeper insight into where the relationships exist. Worksheet Relationship – The worksheet relationship analyzer takes the workbook relationship to a finer level of granularity, by specifying the actual worksheet that contains the relationship, starting at the current workbook level. Dashboards that are self-created by end users, perhaps? This is really handy for big messy corporate environments that can have links pointing to other documents all over the enterprise. For example, let’s say I created a link to another workbook in my environment, say Exotic fruits, with a reference that returns the value in that workbook. It is smart enough to trace through the entire relationship until it reaches the last child of the chain. Workbook Relationship – The workbook relationship tool analyzes the workbook for any dependencies to other workbooks across the environment. This is very useful for trying to break down some complex enterprise workbooks, especially ones used for financial analysis. You can see we can break down formulas into their various categories, unique, numeric, datetime, nested IF’s, etc. Save the workbook, and click the Workbook Analysis icon A report window will appear with a detailed analysis of everything in the sheet: To demonstrate, I’ve created a very simple workbook that connects to another workbook on my machine, and has some fruit and numbers on it. ![]() Workbook Analysis – the workbook analysis icon investigates everything about the current workbook: connections, hidden sheets, formulas, even links to other workbooks. A tab in the ribbon will appear for it, with the following icons: First, to enable the inquire tab, go to File->Options, and select Add-Ins, then COM Add-Ins:Ĭheck the box next to Inquire, and select OK. In this post, I’d like to walk through the 8 icons in the Inquire tab in the ribbon, and what each of them do. ![]() Inquire allows you to do all kinds of things at an excel level, making it much easier to analyze workbooks for formulas, compare dependencies across the environment from both the workbook and worksheet level. Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Project Online Desktop Client Publisher for Microsoft 365 Visio Plan 2 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Project Standard 2021 Publisher 2021 Visio Professional 2021 Visio Standard 2021 OneNote 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Project Standard 2019 Publisher 2019 Visio Professional 2019 Visio Standard 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Project Standard 2016 Publisher 2016 Visio Professional 2016 Visio Standard 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Access 2013 OneNote 2013 Project Professional 2013 Project Standard 2013 Publisher 2013 Visio Professional 2013 Visio 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 OneNote 2010 Project 2010 Project Standard 2010 Publisher 2010 Visio Premium 2010 Visio 2010 Visio Standard 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007 Access 2007 OneNote 2007 Publisher 2007 Visio 2007 Visio Standard 2007 InfoPath 2010 InfoPath 2013 InfoPath Filler 2013 SharePoint Workspace 2010 More.Quietly, Microsoft released a new feature with Excel 2013 Professional called Inquire.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |