close

Lately I have been having issues with the AutoFilter on a few
select workbooks. These workbooks are not necessarily huge (less that 2M).

Here's my Excel 2003 problem - no matter how I activate the AutoFilter...
whether I highlight an entire column, a set of data, or a row of data, the
filter does not work properly. The arrows appear??but when I try to click on
the arrows they do not quot;clickquot; and no data is shown. If I close Excel and
re-open the same workbook it sometimes will allow me to filter once or twice
but then it stops working. When it stops working after I have filtered and I
unselect quot;AutoFilterquot; under the Data menu the data does not quot;expandquot; it
remains quot;filteredquot;, the filter arrows disappear, and I have to unhide rows to
expand my list manually. All other aspects of the spreadsheet work properly.
It does not ?ock up??it is only the AutoFilter that does not work properly.
Is that weird or what? How can I fix this?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()