I have pasted 2016 code on function sheet but it's showing #REF! on cell. Any solution for this issue?

Please I am facing the same problem. I need help on this

Hi, Can you please share a screenshot so that I can take a look? Thanks!

Even I am facing the same issue PS : Got to know how we can change that. just select all the cells which is showing that error and click on the tiny options menu that appear to the downward right if the cell and click on - show values only. Hope this helps