Excel 2007 Formulas look different

U

User13

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?
 
S

Sean Timmons

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

T. Valko

In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK out

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK out
Anyone know why this changed
Click to expand...

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

--
Biff
Microsoft Excel MVP


User13 said:
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formulas look different 3
Can't save my Office documents (after computer rebuild and reauthorization) 0
Help with an IF Statement 1
Require formula to search across multiple worksheets 2
Synchronization problems while moving folders to new email 1
Excel does not accept text format! 0
Index and Match 5
Getting a formula to reflect added columns 10

Top