R1C1 reference style won't stay gone

[Binraider]

Every time I copy and paste cells in a specific workbook it changes the reference style to R1C1. Setting it back in the options, saving the document, closing Excel then reopening brings it back as A1 referencing but copy and paste will again return it to R1C1.

I've checked for VB code and there's nothing there either.

Any Thoughts....

 

[Jerry Sullivan]

That's very unusual.

Does this happen when you copy cells within the same sheet, from one sheet to another in the same workbook, or to/from another workbook into your troublesome workbook?

Is there any chance you have code in your Personal.xlsb file or an Add On that is causing this?

Maybe try running this as a Test before doing the copy process that you know triggers the reset to R1C1:

Sub Disable_Events()
    Application.EnableEvents = False
End Sub

What version of Excel are you using? Perhaps save the file as .xlsx format to ensure there is no VBA code that you might have missed.