Delete row on new data added to an external data range

[agagnon]

I am working on a data table from an external data source. (with a connection with a .iqy file)
On the Data table created by this connection, in the Connections group, click Properties.
Under "If the number of rows in the data range changes upon refresh" you have 3 choices with radio buttons
-Insert cells for new data, delete unused cells
-Insert entire rows for new data, clear unused cells
-Overwrite existing cells with new data, clear unused cells

What i'm trying to do is the same thing as the second choice, but instead of clearing the unused cells I want to delete the row completely if it was deleted in the external data source.

Is there a way to do this on the refresh?