2007 Structured Reference auto-completion not working completely?

S

SVanDee

In Excel 2007, when I:
1) Select a cell
2) Type "=" in the formula bar
3) Click a cell in a Table
I thought Excel would add a Structured Reference to the formula. Instead, it
just inserts an old-style, "A1" reference. The "Formula AutoComplete" and
"Use table names in formulas" options are both turned on. When I click the
cell in step 3, the TableTools tab appears so Excel agrees that the cell is
in a Table. Isn't Excel supposed to insert a Structured Reference when you
click a cell in a Table? Is there another setup/configuration switch
somewhere I need to turn on?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum and Dmax with structured references 1
Structured references between worksheets 0
Excel does not accept text format! 0
Setting column width in a table with a macro is not working 0
Cross reference drop down not activating 1
Menu Macro Not Executing - Need Help 1
Using <= in countifs statement 1
How to add cell's reference to cell's content 5

Top