Forum Discussion
Inquire Worksheet Relationship doesn't detect relationship if formulas use structured table refs
I'm building a corporate Budget workbook that uses many tables (aka listobjects) on many sheets. For clarity and ease, I use structured references to tables like:
=ROUND(SUMIF(EmpData[[CC]:[CC]],B...
Moreover, if you click on Workbook Analysis and check the formulas in result your one will look like
=ROUND(SUMIF(#REF!,#REF!,#REF!,0)