Forum Discussion
Brandon Christensen
Jan 04, 2017Copper Contributor
Problems with Structured References
Hi, I would like to use structured references to tables in my workbook. I was doing so successfully for some time, and then Excel 2013 just seemed to quit recognizing the tables. As an example, previ...
SergeiBaklan
Jan 04, 2017Diamond Contributor
Hi Brandon - could be other reasons, but on your picture it works as expected. You shall click the table at the same row where you enter the formula to have structured reference. You enter formula in F6, if you click on C6 it shall be =SUM(Table1[a]... , if you click on C5 it's as you have =SUM(C5...