• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Field name not highlighting when using structured references

MSC Bobs

MSC Bobs

Member
Hi everyone,

It's been awhile since I've created a new spreadsheet, so I don't know if my problem is because of an update I didn't know about of if there's another reason for it.

I use single cell arrays a lot and until now they've been reliable. When I start a formula, a drop down will display when I start typing my table name. I can select it without having to type in the full name. No problem there. Then I type in a left square bracket to isolate the field and no field names display with which I can select. I actually have to type in the full name of the field.

I didn't intentionally make any changes to settings. I doubled check in the Options > Formulas that the turn on table names is selected.

I'm at a loss and hoping someone can help so that I can select a field from a list without having to type it in. Thanks.
 

Attachments

  • demonstration.xlsx
    19 KB · Views: 6
I suspect it's got something to do with the fact you have a fullstop in the table in, if you remove it the field names will appear in the selection menu.
 
Fluff13 said:
I suspect it's got something to do with the fact you have a fullstop in the table in, if you remove it the field names will appear in the selection menu.
Click to expand...

Thanks for the response. I'm not sure I understand what you mean by "fullstop" in the table. What is that and how can I fix it?

I even pulled up one of my older spreadsheets, created a new tab, and tried to add some stuff up and wasn't getting a drop down on the field name.
 
Last edited:
Oops missed a bit, it should have said "in the table name."
So your table name is tbl.data if you change it to tbldata or tbl_data then you will get the autocomplete for the field names.
 
Fluff13 said:
Oops missed a bit, it should have said "in the table name."
So your table name is tbl.data if you change it to tbldata or tbl_data then you will get the autocomplete for the field names.
Click to expand...

That was it exactly, thanks for the tip. I've been using that dot syntax in my table names for six years with no problem. So it makes perfect sense that Microsoft would change it in 2020.
 
@MSC Bobs
I got caught out with the LET function. Suddenly I was unable to enter the 'period' into a local name despite having done it when the function came out.
@Fluff13
Well spotted. I had got as far as determining that my workbooks still supported IntelliSense for the field names whereas this workbook didn't. I have had similar problems before with the old .xls files but didn't identify the issue here. Had you come across it before?
 
No I haven't, but then I very rarely use tables & have never seen a table name that includes a period.
As I could find nothing in the options for that specific sheet/book, which would account for the behaviour, I simply tried removing the period to see what would happen & it worked.
 
You must log in or register to reply here.
Back
Top