Sorry, I missed the subject.
Tools|Options|General tab|uncheck R1C1 reference style.
This option is picked up from the first workbook you open in that session. So
if someone is saving a workbook in R1C1 reference style, and you're unlucky
enough to open that workbook first, you'll have to change it again.
It could be a fight to the finish!