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.
--
Yasaf Burshan

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)

"Yasaf Burshan" <(E-Mail Removed)> wrote in message
news:C176A93D-88A2-4E28-B71E-(E-Mail Removed)...
> 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.
> --
> Yasaf Burshan

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.

Yasaf Burshan wrote:
>
> 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.
> --
> Yasaf Burshan

--

Dave Peterson

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Yasaf Burshan" <(E-Mail Removed)> wrote in message
news:C176A93D-88A2-4E28-B71E-(E-Mail Removed)...
> 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.
> --
> Yasaf Burshan