G
Guest
I have a worksheet with about 5,000 lines. When I try to autofilter on a
selected item from the dropdown menu, it displays many more cells that don't
contain that value (including blank cells) and indicates only 1 line was
found. I've never encountered this problem before with autofilter.
BTW, in case it means anything, the workbook was originally a shared
workbook. I "unshared" it before applying the autofilter. And, I did try to
copy and paste special, values only, into a new workbook. Same problem and
results.
Any thoughts from anyone? Thanks in advance.
selected item from the dropdown menu, it displays many more cells that don't
contain that value (including blank cells) and indicates only 1 line was
found. I've never encountered this problem before with autofilter.
BTW, in case it means anything, the workbook was originally a shared
workbook. I "unshared" it before applying the autofilter. And, I did try to
copy and paste special, values only, into a new workbook. Same problem and
results.
Any thoughts from anyone? Thanks in advance.