Newbie question about referencing data

[am_]

I have an SQL table. I want it to be retrivied to my excel file. 

1. I use PowerBI to get Data from SQL Server

2. Query1 worksheet shows up with the data.

3. I use formulas like this ='Query1'!D2 in other worksheets to reference the data I want.

The problem is that when I delete one row in the SQL table all the worksheets that reference to Query1 do not update. Instead they create monsters like this ='Query1'!#REF!

I learned why it happens. I want to know the solution how to overcome this. 

[AllisonKennedy]

@am_ 

This is a tricky question - why do you want cell D2 in the formulas you're creating? And why are you deleting the row in Excel? If you delete the row from SQL, and refresh the query, then you shouldn't get this problem. Likewise if you can use DAX instead of excel formulas you can eliminate the ref errors, but we need a bit more info to understand what you're trying to acheive. 

[am_]

If you delete the row from SQL, and refresh the query, then you shouldn't get this problem.

This is what I do. I delete the row from SQL then click Refresh All in Excel and cells with #REF appear.

EDIT. 

Let me be more precise. For example. I have formulas from ='Query1'!D2 to ='Query1'!D300 in one of my worksheets. I delete one row from SQL (not Excel) then after it is reloaded one formula is changed to ='Query1'!#REF!