INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

Excel: Structured table reference & column names. Column names not recognized.

Excel: Structured table reference & column names. Column names not recognized.

Excel: Structured table reference & column names. Column names not recognized.

(OP)
I have created a table in excel using Ctl+t

The headers appear filtered.

If I try to create a formula referencing the table, I get the name of the table automatically, but I cannot get the names of the columns.

=sum(tbl_Sales) the named table "tbl_sales" appears and I can use tab to autofill. But that is as far as I get.

=sum(tbl_sales[ and no dropdown. If I fill in with the column name, I get a broken formula error.

I have tried: =sum(tbl_sales[@[ no dropdown. Again, if I complete the formula with the column name, I get a broken formula error.

In design view, the header row is checked; filter button is checked and the entire range, including column names is highlighted.

It is surely something simple, but what I do not know. What am I missing?

Thank you.

2Rowdy

RE: Excel: Structured table reference & column names. Column names not recognized.

Hi,

Please upload your workbook. I'll take a look.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Excel: Structured table reference & column names. Column names not recognized.

(OP)
Thank you Skip. The issue I am inquiring about is contained in a workbook from a free online instructional video which is copyrighted.

To demonstrate the problem I was having,I created a different table for you in a new worksheet. ...but, the function I am trying to learn, works!
I don't know what the issue is with the workbook from the online course, but the problem is contained within the workbook sheet itself. I can copy that sheet to a new workbork and the issue remains.

I guess we can consider the issue resolved.

Again, thank you.

2Rowdy

RE: Excel: Structured table reference & column names. Column names not recognized.

Well the upstory is that you're getting into the Structured Table feature which is one of Excel's neatest features, packed with all kinds of goodies from Santa.

You'll find new stuff in Structured Tables, like new unknown reindeer you never knew existed. For centuries people thought there were only 8. Then they found Rudolph. But wait! There's more! Olive, the other reindeer; they shouted out with Glee; Santa came to Say for advice; the most famous reindeer Ofall.

Merry Christmas!

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close