If this is so then the implication is that there are no new rows; in other
words the query is returning the exact same result set. Are you sure that a)
the underlying data in the database has been added to and b) your query is
written properly to include the new data?

I would suggest going back into MSQuery ("Edit Query") and see what the
results look like if you rerun the query in there.
--
- K Dales


"orlya1" wrote:

Hello,

I'm using EXCEL XP, and connecting to data source (ODBC).

I marked the "insert entire rows for new data" in the extarnel data range
properties dialog box, but when refreshing the data, no new rows added.

I tried several times,but no good. will appriciate any answer.

thank you!