R1C1 Referency Style Policy

[Jasper Recto]

Is there a way to prevent the R1C1 reference policy from being used in excel
by using a group policy?

If not, how can I prevent it from being the default setting?

Thanks,
Jasper

 

[Shane Devenshire]

Hi,

to the best of my knowledge R1C1 style is not the default, A1 style is.

 

[Dave Peterson]

This setting is picked up from the first workbook that you open in that
session. I don't think you can change the default behavior.

You could use an application event (selection change???) that changes the
reference style to what you like--but what about the people who like this
setting.

I know I very rarely use it, but I do like it when I'm checking formulas in a
column for consistency -- or writing a macro and I want to check my .formulaR1C1
string.