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

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. :)

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

Tools--Options--General uncheck R1C1 reference style.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Clare" wrote:

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. :)

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

Clare

Go to ToolsOptionsGeneral and uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Tue, 3 Apr 2007 10:44:11 -0700, Clare
wrote:

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. :)