Trouble 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, previously when I was entering a formula and clicked to a column in a table Excel would automatically add the structured reference. Then today it just quit. Now when I click into the table it adds in a direct reference instead of a structured reference. As if the table isn't even there. The table is imported from Access, but that never seemed to be a problem before. I found a similar issue here:

http://www.excelforum.com/excel-form...or-tables.html

This solution didn't work for me. My spreadsheet has always been .xlsm

I confirmed the table does indeed exist, I am able to see and edit it's properties and I see it in the name manager.

I also tried just entering the structured reference manually but Excel wouldn't accept it as valid formula.

I attached a picture showing excel auto populating the direct reference instead of the structured version. I am absolutely stuck, any help would be greatly appreciated,

Capture.PNG

I didn't know that was even an option, but I checked and the option is On.

Hi, thanks for the answer. This solution doesn't fix my issue. The table is already (inexplicably) behaving as if it was converted to a range. I want it to behave as a table so that I can use structured references. I am thinking about abandoning this plan all together and just use direct references. If I have to, this is the approach I will take, but I lose the functionality of the table being linked to Access in that case. Not the end of the world, but not my goal either.

I did try this solution, but of course the structured references didn't work because the data was no longer defined as a table. I then re-imported the table, but this didn't fix my issue.

I didn't know that was even an option, but I checked and the option is On.

I figured this out. As with most of my excel issues it's almost always the "user" that is the problem. Thanks for everyone who helped. The solution is simple. The reason why Excel changed behavior on me was because my table, upon updating from Access, went from having only 1 row of data (as a test) to several rows. When I had 1 row, excel added the structured reference when I clicked on 1 cell in the column as that one cell was entirety of the data for the column. After adding more rows I am required to select more then 1 cell of the column to get the structured reference.