Excel table reference (structured) change to absolute range (A1) after re-opening

Question

I have a Table named table2 on my sheet2, and I'm using its values on sheet1 with the help of structured references, like:

=average(table2[values])

But after saving and re-opening the file, all my structured references are being converted to absolute references, like:

=average('sheet2'!$A$1:$A$5)

I've already readed the Help page, and made sure that the checkbox "Use Table names in formulas" is checked, and still no clue why it's happening.

@pnuts, you couldn't be more right at the "Média" translation. I've fixed the code there. Thank you. — Gabriel L. Oliveira
– Gabriel L. Oliveira, Commented Jun 10, 2015 at 13:34

000 · Accepted Answer · 2015-08-21 17:25:56Z

0

The workbook I was using was from Excel 97-2003 and was set not to show "incompatible warnings".

At Excel 97-2003 mode, all structured references are changed to absolute ones.

I created another workbook to try, and found the reason.

000

27.3k10 gold badges74 silver badges103 bronze badges

answered May 29, 2015 at 15:42

4,1226 gold badges34 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1