+ Reply to Thread
Results 1 to 5 of 5

Problems with Filters

Hybrid View

  1. #1
    Registered User
    Join Date
    12-22-2004
    Posts
    3
    Other than the unused ones outsie the print area, no.
    There may be blank columns if that has anything to do with it.

  2. #2
    Forum Contributor
    Join Date
    01-11-2004
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    388
    Hi!

    Missing columns (i.e. entirely empty: not even a heading) will act as a barrier if you depend on Excel to delineate your data area. But that doesn't explain your problem.

    I have, however, replicated your behaviour by blanking row2 (below headings), selecting one of the column headings and then activating Autofilter.

    Alf

  3. #3
    Registered User
    Join Date
    12-22-2004
    Posts
    3
    Like i said, there were no rows completely blank.
    Oddly enough, out of 6 people who tried opening the file after the issue was discovered, 2 of them had no problems. I had one of them save the two files and now the problem seems to have disapeared.
    I now know what to do if it happens again, but still have no clue how to keep it from happening again.

    Thank you for your time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1