Filter & sort data tables in excel 2007

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: Last updated:
Related Questions
1

Answer Wiki

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
    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,580 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: