Filters not working correctly

E

EZ

When filtering a table, the filter returns the correct value(s). However, if
you attempt to copy, delete, or format the filtered values, all values are
copied or deleted, even the hidden ones. In Excel 2003, the filter returned
"Visible Cells Only" by default. This is not happening in 2007. I can work
around by gong to Find & Select on the Home tab --> Go to Special and
selecting Visible cells only. This is very tedious and is not the way it
should work. Please let me know what settings I need to change to get the
filters to work correctly.
 
E

EZ

I discovered that this hotfix was already installed by my company. I'm still
having the problem with autofilters. Is there another solution?
 

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

Similar Threads

Filters do not work correctly for table linked to an Access query 1
Applying function after filter is applied 4
Excel 2007 compatibility issue - speed between cells 2
2007 Forms - Quick Filters not working 5
Are Date filters available for items in the Filter area of pivot t 2
How do I VLookup visible cells only? 2
Query Criteria Not Working 2
Macro to copy value in field and insert it into filter 2

Top