Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
external data table sort order
Hi,
I am querying a SQL database view to return a table of data in Excel. The view is setup to sort the data they way I need it so my query within excel is literally "select * from MyView". However in Excel 2007 I now get this fancy data table with filter headers that seem to override my views sort order. If I use the filter to sort a column then this is the dominent sort order even if I remove the filter from the table and refresh the data. So how do I retrieve external data in the order it was intended in? Thanks, Matt -- Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table sort order | Excel Discussion (Misc queries) | |||
Pivot Table Sort Order | Excel Discussion (Misc queries) | |||
sort order of pivot table drill down | Excel Discussion (Misc queries) | |||
Pivot table sort order | Excel Worksheet Functions | |||
Pivot table sort order | Excel Discussion (Misc queries) |