I am having excel file with 2 sheets. One of them is full of formulas that are linked to one, lets say that the name of sheet is sheet1 (just data numbers and text). Formulas are working ok and doing their job but when I am trying to insert (paste) new data to sheet1 formulas on the another sheet are not working at all they are showing #REF. I am using IF statement like this =IF('sheet1'!G14=0;0;'sheet1'!G14).

Thanks in advance.