Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference
style, you'll have to make the change.

Do you save the workbook after you make the change to A1 reference style?

Do you have a coworker who likes R1C1 and saves it that way? (Could mean a
fight!)

Cynthia wrote:

Thank you very much. We had no idea why this happens on occasion.

"Cynthia" wrote:

Occasionally when I launch excel the column headings and row are displayed as
numbers. As a result if you click in cell A1 it will display in the cell
reference box as R1C1. Thus I can not figure out how to type in formulas or
review them since I have not idea what these references mean.

--

Dave Peterson