I have a spreadsheet that pulls data from a SQL view. There will be other
spreadsheets that use the values in these query cells. The problem I am
having is when a new row gets added to the view, it doesn't go to the bottom
(as it shouldn't) and thus gets "inserted" into the appropriate part of the
spreadsheet. The problem is that since no actual "insert" is performed, the
formulas get screwed up because any record below the new one gets bumped
down, but the formulas don't get updated appropriately.

Ex

I have a formula that says =C3+C4

I want the formula to get the specific information in that spot. If I wasn't
using a database query, and needed to insert a row above it, I would insert
the new row and the formula would get updated to be =D3+D4, which is what I
want. However, when the database query adds a new row, the formula stays at
=C3+C4.

Anybody have ways around this?