Excel keeps unilaterally changing reference style to R1C1

Question

Excel keeps unilaterally changing reference style to R1C1

Anonymous

My excel sheets keep changing the reference style to R1C1 for no apparent reason. I have to keep changing back through options but its really tedious. Why is it doing it, and how can I stop it.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Not sure why this is happening but a template file in your XLSTART folder will solve it.

To find where your XLSTART is:

Press [Alt]+[F11] to launch the VBE.
If the Immediate window isn't visible, press [Ctrl]+g.
In the Immediate window, type ? application.StartupPath and press Enter. VBA will display the path to XLStart.

Note the question make; as in ? application.StartupPath . You could just copy & paste this

Make a note of the response. Mine is C:\Users\Bernard\AppData\Roaming\Microsoft\Excel\XLSTART

Open a new workbook

Open Excel > File > Options > Formulas > Uncheck ‘ R1C1 reference style’ under Working with style > click on ‘OK’.

Click on File > Save as > Browse to the XLSTART folder and give the file the name Book.xltx. Press OK

This site might help: http://www.excel-easy.com/examples/default-templates.html

best wishes