Switch on structured referencing

[Rudi]

Hi,

I just cannot find the place to activate this? It seems Excel 2013 (on my PC) does not use structured references? I cannot even find a search result on the internet to activate this? Any ideas how to get Excel using structured references in tables again?
TX

1.jpg

[Rudi]

Argh...found it.
Seems the lounge REALLY does work to help resolve questions.
I was fighting this the whole day and eventually posted the question...then 3 minutes later...I find the solution!! :weird:

1.jpg

[HansV]

So it goes

[Rudi]

In addition to switching on the structured referencing:
While trying to search for where to switch it ON , I did come across and interesting article in which i learned about converting a structured reference into an absolute reference. This article is a very good read and nice and concise...