External Data Query

[Curtis]

I read in a book that it is not a good practice to put
anything below a external data range. I have done this
and have found no problems. What problems has anyone
found doing this?

 

[Guest]

If the external data you import is big enough, it can overwrite your data

----- Curtis wrote: ----

I read in a book that it is not a good practice to put
anything below a external data range. I have done this
and have found no problems. What problems has anyone
found doing this?

 

[Guest]

Wouldn't that have to be a big import to do that? My
imports are probably not that big. I'm only talking for
some reports maybe 1 to 100 rows and for others maybe a
few thousand. How many rows can Excel handle?

 

[Dick Kusleika]

It depends on where your extraneous data is compared to the external data
table. If it's right below it, then it only has to be one line bigger than
it was to overwrite your data. There's an option on the Data Range
Properties dialog about how Excel will handle data around the table. I
describe the three options in this post

http://www.google.com/groups?hl=en&[email protected]