R1C1 settings auto changing

[essential]

Excel Spreadsheet headers/columns A,B,C... are changing after a formula is
performed to numbers 1,2,3... This only happens on one spreadsheet not
others. How do I stop it from automatically changing?

 

[Mike H]

Hi,

It happens if you open a workbook that has the R1C1 settings and I don't
believe you can stop it except by forcing the change back with a macro. in
the workbook open event module

Application.ReferenceStyle = xlA1

Mike

 

[essential]

Compile error. Invalid outside procedure.

What might be the problem here?

 

[Mike H]

Hi,

I don't know what did you do?

You should have done this:-

Alt+F11 to open VB editor. Double click 'This workbook' and paste this in on
the right

Private Sub Workbook_Open()
Application.ReferenceStyle = xlA1
End Sub

Mike

 

[essential]

This Macro hasn't solved the issue unfortunately.

Letters are still changing automatically.

Any other suggestions perhaps?

 

[essential]

Originally I hadn't added the macro correctly. Since trying this Macro it has
not been successful. Are there any other suggestions?