Change R1C1 reference style at start up

[Laura Wilde]

I am currently using Excel 2000. A coworker of mine that prefers the R1C1
reference style used my computer for a short amount of time yesterday and
changed the reference style to their preferance while using it. Now
whenever I open Excel I have to manually go in to Tools > Options > General
and uncheck the R1C1 box. But if I close Excel and then start it back up,
the box is checked again. Is there a way to change Excel's start-up
properties or a solution that may help me?

TIA
--
Laura

Though it can be tedious, I may take the long road, for it is the one that I
know. But if someone has the map for the short road, I'd sure like to take
a look!

[Jason Morin]

Unhide your Personal.xls (Window > Unhide) and uncheck the
R1C1 box there.

HTH
Jason
Atlanta, GA

>.
>

[Dave Peterson]

This is one of those settings that excel picks up from the first workbook that
it opens. If that file had R1C1 style set, and if you open it first (like
double clicking in windows explorer), then you'll get R1C1 style.

If you change back to A1 and save that file, then you'll be set (until you work
on a file you share with your coworker and he/she changed styles and you open
that file first).

You may be in a battle of a lifetime with your coworker--or you could just make
sure you open (or create a new workbook) with A1 reference style before you open
the "battle" workbook.

That's what Jason's post was trying to do. I use personal.xla (hidden) and the
reference style had no affect on my settings. (Maybe another option would be to
make book.xlt in your xlstart and make sure that this workbook has A1 style
set. Then open excel and use File|open to open that other pesky workbook.)

FYI: Excel also gets it calculation mode setting this way (first workbook
opened in a session). Here's hoping your coworker doesn't start messing with
that!

--

Dave Peterson
ec3...@msn.com