Default keeps changing to R1C1

T

Treesy

Every time I open Excel, it puts my reference style as R1C1. I always
uncheck that box under options but it keeps going back to R1C1. I'm getting
very frustrated. How can I change it so the default is having that box
unchecked??

Thanks.
 
G

Gord Dibben

Treesy

The first workbook opened sets the reference style.

Perhaps your Personal.xls is set and saved to R1C1. It always opens first.

Gord Dibben Excel MVP
 
T

Treesy

Thanks for responding. It must be the 2nd thing because even when I open a
blank workbook, it sets it as R1C1. Also, co-workers will be in a workbook
and it isn't set as R1C1 but when I open it, it does.

How do I change my personal.xls?
 
T

Treesy

Nevermind, I think I fixed it. I just realized that I used a shortcut to
open a blank workbook and I think the shortcut had that setting. I've
deleted the shortcut and added a new one, without R1C1 activated. I'm
assuming (and hoping) that this solves the issue.

Thanks for your help.
 
T

Treesy

Okay, so the new shortcut didn't solve the problem. What am I doing wrong??
Can you explain how I can update my personal.xls?

Thanks!!
 
G

Gord Dibben

Assuming your Personal.xls is opening in "hidden" mode.

Window>Unhide>Personal.xls

Make changes to Tools>Options>General then re-hide Personal.xls.

Close out Excel. You will be asked to "save changes to Personal.xls". Click
"yes".

Re-open Excel and a workbook that was saved with R1C1 setting unchecked. What
is the RiC1 options setting?

Gord Dibben Excel MVP
 
T

Treesy

Hrm... I don't have anything to "unhide" I don't think I have a
personal.xls. But I think I figured it out, AGAIN. I have other documents
that I've worked on in the past and they were saved under R1C1. What I
didn't realize this morning was that I had opened one of those files first
thing and that changed my settings for all workbooks opened afterwards. So
when I run across those older files, I uncheck the R1C1 box and resave the
document. So far, so good. :) Thanks again for the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top