Forum Discussion
Spreadsheet Studio formula explorer for Excel 2013+
Will Excel ever adopt a more powerful formula explorer feature that is able to trace precedents similar to the Excel add-in's Spreadsheet Studio formula explorer for those of us who are heavy users of offsets and index/match functions?
1 Reply
It depends on many users would really want this to be added in Excel as built in feature.
There is already some suggestions like this in the Excel user voice. so, if you want something
to be added in Excel. You can vote on https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8782960-add-a-proper-formula-auditing-tool-to-better-trace, or create your own request in the user voice.
Excel 2013 and above, have built-in COMM Addin called Inquire and there you can see the "Cell Relationship" that can trace the formulas thoroughly. Perhaps this is not something you need.
I know more than dozen advanced and very useful add-ins for auditing formulas that are completely free. for example one of them which is also free https://www.formuladesk.com/formula-tools?live
My personal opinion, as long as I can get done whatever I need, and Excel allows us to add additional custom functionalities and features either by VBA/Javascript or third party add-ins. I am happy with it. :)
