Forum Discussion
Excel Table headers - field names list not showing when typing
Hello, Excel automatically creates table names, i.e. Table1, Table2 etc.. If I start typing ="Table1[..", the list of field names automatically pops up after the square brace '[' and I can just s...
Thanks for the reply. I solved the problem.
It seems Excel does not like periods "." anywhere in the name. So if I had a table named "tbl.Table1" I do not see the field names when I type.
However, if I take out the period and rename it "tblTable1" and everything works.
That's definitely a bug. You may use underscore, tbl_Table1, field names are shown with it.
If we speak about desktop version, period works in Excel for web
- good to know
