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

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

The second sheet has R1C1 Reference Style enabled. Follow these steps to fix:

If in Excel 2007:
<Office Button (in top left corner of screen)
<Excel Options
Click on "Formulas" tab
Un-select R1C1 reference style

If in Excel 2003:
<Tools
<Options
I think it's under General Tab (i think... can't remember exactly as i've
been switched over to 2007 for a while now
Un-select R1C1 reference style

--
Regards,
Dave


"User13" wrote:

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

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

Please do not multi-post

Your question has been answered in another group

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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

Hi

Goto Tools Options General In Settings section uncheck 'R1C1 reference
style'.

Regards,
Per

"User13" skrev i meddelelsen
...
I received a spreadsheet of mine back from a coworker, and all the formulas
now look something like =Totals!R[3]C[-1] instead of =TOTALS!C73.

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