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" wrote:

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?