I have a .txt file I bring into excel automatically, and I want to
automatically update my pivot table size to match what is brought in.

If I turn my data into a List (using excel 2003), it kills the link to my
external data but allows me to update the pivot table automatically when
adding rows to the list.

I am only adding to the rows, not the number of columns. Selecting a huge
range of rows to anticipate future data adds "blank" entries to my pivot
table and screws up the data.

Any ideas? Thanks!