Autofilter

J

Juhlup

When I apply a filter and then modify the visible data by either copying a
formula down, or selecting multiple rows and applying a color to the text.
When I remove the filter the action I did is applied to all rows not just the
filtered subset.
 
C

CLR

To circumvent this situation, I copy and paste my filtered results to a new
sheet and do my work on it there.........

Vaya con Dios,
Chuck, CABGx3
 
J

Juhlup

I understand that is an option - but when I do it on a different installation
of 2007 (on a different computer) it works as intended - only effecting the
subset of cells displayed? I just could not understand why it works one way
 
C

CLR

Sorry, I'm not a 2007 user. Perhaps someone else can help, or you can
re-post, explaining the entire situation.

Vaya con Dios,
Chuck, CABGx3
 
P

Pio

I have the same problem with my excel'07, i check all discussion posts and
cant find resolution.
If You'll find some fix please post it.

Thank You,
 
M

Michael Nagy

Hi,
Same problem. Can't quite pin down when it does and doesn't occur.
I have a .xls file opened in compatibility mode which consistently exhibits
this behaviour when freshly opened but after a while the filter behaves
normally and I can no longer recreate the problem.
I haven't been able to recreate the problem in a 2007 converted file yet.

Anyone else made any progress testing?
 

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

Autofilter is Harmful to your Data 3
VBA: How can I use a string variable as autofilter criteria? 4
How to set range to autofiltered visible cells? 7
Count Number of Visible Rows in Filtered View 2
Autofilter-Filtered List Scan 10
Excel Auto Filter - cannot turn off. 2
scrolling stops after I turn off autofilter 1
Excel 2003 autofilter drop down arrows appear in wrong row 2

Top