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

Hello, Do you use Paste special values, please? Can you share a screenshot of the error? Thanks!

Follow this topic

Sakif Hossain

Last answered:

07 Dec 2021

Posted on:

21 Oct 2021

Error showing on cell #REF!

in Introduction to Excel / Learn How to Create a Database

4 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

28 Oct 2021

Muskan Jain

Posted on:

02 Nov 2021

Nita

Posted on:

05 Nov 2021

Ned Krastev

Instructor

Posted on:

07 Dec 2021

Error showing on cell #REF!

Submit an answer

related questions