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 ...
Hi warrevar
From File --> Options --> from the left menu click on formula --> under the working with formula
make sure the option "Use table names in formula" is checked
* If my post helped you, please click on like.
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.