fixing formula after data table update

dears

i have database connection which call a table of data , to use these information I had to insert 2 columns beside that table.
these 2 columns filter out some data from the table then i use it in other worksheets .
Every time i update data table , some rows are added others are deleted and the formula in columns 1 & 2 gives wrong results.
for example " =IF($D931="Active",$C931,"") " while the raw now is 905 .
is there any way to correct this : what is my options to solve this
i can't attach the file is has sensitive and confidential data

Data table.jpg

best regards,

yes it is Excel query,

Please support , move post to where it should be (Y)

regards,