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.

Jasper Recto wrote:

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

--

Dave Peterson