True. Just don't sort the array-entered portion -- the array-entered formulas will recalculate quickly after you sort the column that includes the ticker symbols.
Or, if you want to sort on one of the returned fields, just reference it in a column that is part of the database that can be sorted. Or, you could just array-enter it by row and copy down. That would at least cut your access down to 400 Internet data retrievals instead of 3200. On 9/4/07, Don Lindberg <[EMAIL PROTECTED]> wrote: > I see the value of the array entry for speed of download, but I want the > capability of sorting > the data on different columns, and my understanding is Excel doesn't allow > you to move cells > that make up an array formula. If I am wrong in my assumption please let me > know.
