insert entire row for new data, external data range doesnt work

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!

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!
>
>
>
>

Thank you for your answer,

if I delete rows from the excel sheet, and then refresh it,

?so they appear again, this action is not suppose to create new rows

the creation of new rows is just when new row added to the DB or the sheet?





"K Dales" wrote:

> 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!
> >
> >
> >
> >

The setting for "If the number of rows in the data range changes upon
refresh..." specifies how to fit the query results range onto your sheet as
the size of the result set changes. The main reason is to avoid moving other
data that might be on the same sheet. Consider if you were doing this
yourself: inserting rows might break up another list somewhere to the right
on the same sheet.

But it does not imply that every time you run the query it adds new rows for
the results (i.e. listing the data again). The results of the query will
always be a single continuous range containing one set of results from the
latest run of the query.
--
- K Dales


"orlya1" wrote:

> Thank you for your answer,
>
> if I delete rows from the excel sheet, and then refresh it,
>
> ?so they appear again, this action is not suppose to create new rows
>
> the creation of new rows is just when new row added to the DB or the sheet?
>
>
>
>
>
> "K Dales" wrote:
>
> > 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!
> > >
> > >
> > >
> > >