Peter Bartholomew
Well-Known Member
This is a problem I have encountered with spreadsheets downloaded from this forum.
If the workbook contains lists held as a column of ordinary cells, I often convert them to Tables to provide me with a reference notation I am comfortable with. What I have noticed is that clicking on a cell or field heading then gives me references in the A1 notation rather than the structured references I am expecting.
I have checked Options / Formulas and confirmed that the option box “Use table names in formulas” is checked. I can still type the structured reference but that is not much of a consolation. Has anyone else encountered this?
Do you know what causes it to happen?
If the workbook contains lists held as a column of ordinary cells, I often convert them to Tables to provide me with a reference notation I am comfortable with. What I have noticed is that clicking on a cell or field heading then gives me references in the A1 notation rather than the structured references I am expecting.
I have checked Options / Formulas and confirmed that the option box “Use table names in formulas” is checked. I can still type the structured reference but that is not much of a consolation. Has anyone else encountered this?
Do you know what causes it to happen?