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]],Budget[@[CC]:[CC]],Salaries[Jul]),0)
where EmpData and Salaries tables are both on a Salaries sheet. The formula is within Budget table on Budget sheet. When I save the file, go to the Inquire tab and click Worksheet Relationships, the dependency of Budget sheet on Salaries sheet is not detected/shown.Worksheet Relationships
Curiously, if I run Inquire Cell Relationships, the relationship is detected!
If Cell Relationship detects F3s dependencies on the Salaries sheet, why doesn't Worksheet Relationship detect that the Budget sheet is dependent on the Salaries sheet?
2 Replies
- Why that is was going to be my next question. At least there's a VBA solution for that.
Moreover, if you click on Workbook Analysis and check the formulas in result your one will look like
=ROUND(SUMIF(#REF!,#REF!,#REF!,0)
