Cell References: R[-2]C[0] vs A10
 

One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to R[x]C[y] references.

How to I restore the default reference system???

Thanks

Cell References: R[-2]C[0] vs A10
 

In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"Arthur" wrote in message
...
One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to R[x]C[y] references.

How to I restore the default reference system???

Thanks

Cell References: R[-2]C[0] vs A10
 

Thanks Biff, that did it.

Now, how that ever got turned on I don't have a clue.
Well maybe, Excel did crash and the restored file came back that way.

Thanks again.

Arthur

"T. Valko" wrote in message
...
In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"Arthur" wrote in message
...
One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to R[x]C[y] references.

How to I restore the default reference system???

Thanks

Cell References: R[-2]C[0] vs A10
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Arthur" wrote in message
...
Thanks Biff, that did it.

Now, how that ever got turned on I don't have a clue.
Well maybe, Excel did crash and the restored file came back that way.

Thanks again.

Arthur

"T. Valko" wrote in message
...
In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"Arthur" wrote in message
...
One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to R[x]C[y] references.

How to I restore the default reference system???

Thanks

Cell References: R[-2]C[0] vs A10
 

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

If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough
to open a workbook that he saved as the first workbook in that session, you'll
be making the same change again.

So make a note of Biff's suggestion.

And then start a reference style war at your place of business!!!

Arthur wrote:

Thanks Biff, that did it.

Now, how that ever got turned on I don't have a clue.
Well maybe, Excel did crash and the restored file came back that way.

Thanks again.

Arthur

"T. Valko" wrote in message
...
In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"Arthur" wrote in message
...
One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to R[x]C[y] references.

How to I restore the default reference system???

Thanks



--

Dave Peterson