Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Excel 2003 isn't filtering

I have an ODBC query going into Excel 2003. When I go to Data, Filter, Auto Filter, i then go to any of the columns to sort Ascending. When I do this, it sorts a lot of data Ascending, but then there are random blank cells, then more data below...that should have been part of the filter. No matter what column i filter, this happens. Is there a property setting i'm missing? We have never had this issue before.
0
brasiman
Asked:
brasiman
1 Solution
 
NBVCCommented:
Before applying Data|Filter, actually select all the columns first, then apply Data|Filter.

When you don't do that, sometimes the data in the autofiltering stops at the first blank row...
0
 
brasimanAuthor Commented:
It looks like that is working for now. We have tried that before but I was thinking it still didn't work after that. But for now, it's holding. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now