I have spreadsheets linked to external data sources but I also need to add
data to them. Whenever the data source is refreshed rows are correctly added
or deleted from the columns containing external data but not from the columns
containing my data. My rows end up not corresponding to the external data
rows. I thought designating the entire data range as alist might help but I
recieved an error that says you can't make a list that contains external
data. Any one have suggestions?