I received a spreadsheet of mine back from a coworker, and all my formulas
now look like =Totals!R[3]C[-1] instead of what I originally used =TOTALS!C73.

Anyone know why this changed, and how to change them back?
--
User13

Office buttonExcel OptionsFormulas tabuncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"User13" wrote in message
...
I received a spreadsheet of mine back from a coworker, and all my formulas
now look like =Totals!R[3]C[-1] instead of what I originally used
=TOTALS!C73.

Anyone know why this changed, and how to change them back?
--
User13

click on the multi-colored button on top left, then click Excel Options on
bottom. go to general tab and uncheck R1C1 reference style.

"User13" wrote:

I received a spreadsheet of mine back from a coworker, and all my formulas
now look like =Totals!R[3]C[-1] instead of what I originally used =TOTALS!C73.

Anyone know why this changed, and how to change them back?
--
User13

In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK out

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out

Anyone know why this changed

The coworker may have had their version of Excel set to use R1C1
referencing.

--
Biff
Microsoft Excel MVP


"User13" wrote in message
...
I received a spreadsheet of mine back from a coworker, and all my formulas
now look like =Totals!R[3]C[-1] instead of what I originally used
=TOTALS!C73.

Anyone know why this changed, and how to change them back?
--
User13