Unknown Formula: R[-1]c/r[4]c[-6]

C

Clare

End-user "saved as" budget worksheet w/known formulas and multiple workbooks.
When she opened new workbook, all the formulas were similar to "
R[-1]c/r[4]c[-6]"

Please let me know if you have seen this. :)
 
G

Gord Dibben

Clare

Go to Tools>Options>General and uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP
 
Top