Can't Cancel r1c1 cell referencing in excel 2007

Y

Yasaf Burshan

Hello,
I have excel 2007 running on XPSP2.
I can't cancel the r1f1 reference style (whenever I re-open excel its turned
on again).

How can I resolve this issue?
Thanks.
 
B

Bob Phillips

That means that you must have a workbook that is setting it. Look at
personal.xlsx.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
D

Dave Peterson

Excel picks up this setting from the first workbook you open in that session.

So you can open excel
Open a workbook
change to A1 reference style
Save that workbook
close excel

Then to test:
Open excel
open that workbook

If you still see R1C1 reference style, then maybe your personal.xls* workbook is
in R1C1 reference style.

Open excel
Unhide Personal.xls*
change to A1
Hide personal.xls*
close excel and when prompted to save personal.xls*, answer yes.

Then close excel and retest.
 
J

Jon Peltier

I've had that problem only in 2007 when programmatically manipulating
workbooks, workbooks that when opened manually worked in A1. Some workbooks
were 2003 format xls files, some were 2003 0r 2007 Excel files with
different extensions (i.e., not .xls*). I never got to the bottom of it, but
resorted to a line of code resetting the reference style after opening the
workbooks.

Excel 2007 doesn't really like Excel workbooks with different extensions,
FWIW.

- Jon
 
Top