Filter & sort data tables in excel 2007

Helenacvdm

5 pts.

Tags:

Data Tables

Excel 2007

filter

MS Query

When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn't allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two ranges separately and will only filter the extra columns to the right but not the first lot on the left.

Software/Hardware used:
XP, office 2007

Asked: March 25, 2010 12:59 PM Last updated: April 26, 2010 2:28 PM

Answer Wiki

Last updated: April 24, 2010 4:43 PM GMT

Chippy0884,625 pts.
History
Contributors
- Ordered by most recent
- Chippy0884,625 pts.

Thanks. We'll let you know when a new response is added.

Are you forgetting the power of the filter and sort in MS query?

Write the query to filter and sort, then pass the result to excel.

Discuss This Question: 1 Reply

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

carlosdl Apr 26, 2010 2:28 PM GMT

That's an option, but the query would need to be modified if a different filter needs to be applied or a different sorting is needed.

84,535 pointsBadges:

report