Forum Discussion
#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...
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)