R1C1 reference
 

Excel keeps changing to the R1C1 reference style, but only in one of my
workbooks (I believe in just one of the worksheets). I keep changing it back
(Tools - Options - General - R1C1 Reference Style), but when I move or copy
cells in the workbook, it changes back to R1C1. Anyone have an idea?

Look at the
TOOLS / OPTIONS / SETTINGS
is the 'R1C1 References Style' box checked?
If not, check it then save the workbook.
Not sure if this is your issue but it's worth a try.
Good Luck,
--
Gary Brown



"Tony S" wrote:

Excel keeps changing to the R1C1 reference style, but only in one of my
workbooks (I believe in just one of the worksheets). I keep changing it back
(Tools - Options - General - R1C1 Reference Style), but when I move or copy
cells in the workbook, it changes back to R1C1. Anyone have an idea?