Auto Filter problem - No list was found

P

Paul

I've got two worksheets in a file that I have been using filter's on all
year. Each month I add more columns and "hide" older previous month columns.
I always clear out the data filter and then re-add it just for current
months data. This worksheet currently goes to column BV and row 286. I'm
hiding columns F thru BI and the auto-filter starts at BJ all the way to BV.
I also have frozen panes involved. Anyway, all has worked fine until now and
now no data comes up in the auto-filter list. When I only select one column
I get the error that "No list was found". I've not done anything different
this month than in previous months. I have "unhide" all columns and then did
an auto-filter on all columns with data and it works fine but I don't need
it on all columns, just the current month.

The other worksheet is the same and is working fine. It goes all the way to
column ES and row 727.

I get the same results using Excel 97 and Excel XP.

Can anyone provide any help on this? I can provide the spreadsheet which is
about 300k compressed.

Thanks a bunch,

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top