I have a query in a workbook and want to sort this by one of the column values can this be done? If so is this at the query level or workbook and how? Thanks
yes, this can be done.
you can right click the column after query executed, in excel sheet, and choose 'sort' ->ascending/descending.
save the query as query view -> click bex button save -> save view global.
hope this helps.