Forum Discussion

Benyamin Bayat's avatar
Benyamin Bayat
Copper Contributor
May 31, 2017

#REF!

I have received one Excel sheet, the formulas have referenced to the previous editor. so as I delete one column or row it gives me #REF! error.

I have taken a look at Microsoft https://techcommunity.microsoft.com/t5/Excel/REF/m-p/59135#M564 page but it tells me to adjust formulas.

 

My problem is that the references are linked to previous editor desktop.

What should I do? I need your aid. 

 

thanks in advance

 

excel

2 Replies

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Iron Contributor
    May 31, 2017

    Convert all Formula in to Values by

     

    Selecting All the Formula put by previous editor.

     

    Copy them.

     

    In Paste option, select paste special (paste them as values)

Resources