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...
Why that is was going to be my next question. At least there's a VBA
solution for that.