formula works in one sheet but not in the other

can you please explain why my formula does not work in one sheet?  

in any sheet, it works. but if you put it in that one single sheet called "put formula anywhere here" then the formula returns zero  why????????
Example.xlsx
LVL 6
FloraAsked:
Who is Participating?
 
ProfessorJimJamCommented:
File - Options - Advanced
Scroll all the way down
under the lotus compatibility setting for > select the sheet with problem and then uncheck uncheck 'Transition formula evaluation" and "transition formula entry"

2017-11-28-00_13_38-Excel-Options.png
click ok and that is it.
1
 
FloraAuthor Commented:
It worked thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.