excel Delete Row #reference error in formula
<p>Could someone tell me if right now there is some way to prevent #reference error in formula in one sheet when i want to delete row in another sheet (formula contains a reference on a cell in that sheet). ps. I do not want to use indirect function because it is volatile.</p>

<p>thank you in advance.  </p>