Forum Discussion
Structured References - How to Keep Them From Toggling Off?
Excel keeps toggling off my formula structured references. For instance, I input the following formula: =INDEX(_TABLE3[COLOR],MATCH($B5,_TABLE3[NAME],0)) Then I save / close the file. When ...
Jihad Al-Jarady I'm using excel 2010, which has different menus. Unfortunately, this does not seem to be an option in this earlier version.
Is that happening with all the worksheets? or just one?
If it is with one worksheet, did you convert the table range? structured references works with tables
Jihad Al-Jarady yes, it is within all of the tables on all of the worksheets within the workbook.