Home

Spreadsheet Studio formula explorer for Excel 2013+

%3CLINGO-SUB%20id%3D%22lingo-sub-283727%22%20slang%3D%22en-US%22%3ESpreadsheet%20Studio%20formula%20explorer%20for%20Excel%202013%2B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283727%22%20slang%3D%22en-US%22%3E%3CP%3EWill%20Excel%20ever%20adopt%20a%20more%20powerful%20formula%20explorer%20feature%20that%20is%20able%20to%20trace%20precedents%26nbsp%3Bsimilar%20to%26nbsp%3Bthe%20Excel%20add-in's%20Spreadsheet%20Studio%20formula%20explorer%20for%20those%20of%20us%20who%20are%20heavy%20users%20of%20offsets%20and%20index%2Fmatch%20functions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-283727%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormula%20Explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPrecedents%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESpreadsheet%20Studio%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285353%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20Studio%20formula%20explorer%20for%20Excel%202013%2B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285353%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20depends%20on%20many%20users%20would%20really%20want%20this%20to%20be%20added%20in%20Excel%20as%20built%20in%20feature.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20already%20some%20suggestions%20like%20this%20in%20the%20Excel%20user%20voice.%20so%2C%20if%20you%20want%20something%20%3CBR%20%2F%3Eto%20be%20added%20in%20Excel.%20You%20can%20vote%20on%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F8782960-add-a-proper-formula-auditing-tool-to-better-trace%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F8782960-add-a-proper-formula-auditing-tool-to-better-trace%3C%2FA%3E%2C%20or%20create%20your%20own%20request%20in%20the%20user%20voice.%20%3CBR%20%2F%3E%3CBR%20%2F%3EExcel%202013%20and%20above%2C%20have%20built-in%20COMM%20Addin%20called%20Inquire%20and%20there%20you%20can%20see%20the%20%22Cell%20Relationship%22%20that%20can%20trace%20the%20formulas%20thoroughly.%20Perhaps%20this%20is%20not%20something%20you%20need.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20know%20more%20than%20dozen%20advanced%20and%20very%20useful%20add-ins%20for%20auditing%20formulas%20that%20are%20completely%20free.%20for%20example%20one%20of%20them%20which%20is%20also%20free%20%3CA%20href%3D%22https%3A%2F%2Fwww.formuladesk.com%2Fformula-tools%3Flive%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.formuladesk.com%2Fformula-tools%3Flive%3C%2FA%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20personal%20opinion%2C%20as%20long%20as%20I%20can%20get%20done%20whatever%20I%20need%2C%20and%20Excel%20allows%20us%20to%20add%20additional%20custom%20functionalities%20and%20features%20either%20by%20VBA%2FJavascript%20or%20third%20party%20add-ins.%20I%20am%20happy%20with%20it.%20%3A)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
David A
Occasional Visitor

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-..., 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. :)


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies