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
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