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
Bookmarks