Sorting data resulting from Query in Excel

  • Thread starter Thread starter Fortarel
  • Start date Start date
F

Fortarel

We use Query in Excel extensively, retrieving info out of a SQL database.
Using Excel 2007, the data that comes back from the query (table)
automatically shows up with filters. It's easy to turn off the filters, but
if you try to sort a subsection of the returned data, it automatically sorts
the whole table - you can't sort a subsection. With Excel 2003 there was
never any problem.
 
Hi,

Well it seems to be related to the fact that Excel 2007 creates a table for
the data connection, and worst, if you convert the table to a range it say
you will loose the data connection.

You can manually sort in the table but that is a waste of energy. Depending
on the type of data that is in the field you want to sort on you can create a
custom sort order via the Custom List feature and then apply that in the Sort
command, under Order, Custom List.
 
Back
Top