Excel 2007 Problem with Filter

P

paul.mcmaster

Is anyone else having major problems with Filters and actions
affecting hidden cells.

The problems I am having with filtered lists are that actions such as
"FILL DOWN", DELETE or CLEAR are being applied to both visible as well
as hidden cells.

It appears to be happening haphazardly, the only way I can tell if the
problem will happen is if I select a range of rows that includes
visible and hidden rows, and right click. If I see "Delete Rows" then
there will be no problem. If I see "Delete" then cells filtered out
will be affected.

I never had this problem in XP.

Is it just me or is this a widespread bug. So many of my colleagues
have given up on 2007 and reverted back to XP - I dunna want to.

Help please?
 
M

Micahel Nagy

Hi Paul,
We're seeing this behaviour too. I see no responses to queries on this bug.
Did you have any luck getting an answer or narrowing down when this occurs?
Does it only occur in compatibility mode? Most probs we've had converting to
2007 has been using 97-2003 files in compatibility mode: when I convert them
to 2007 they are moere reliable.

Cheers,
Michael
 

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

Dealing with the error: unable to filter on excel hc home school 0
MAJOR problems with 2007 Filters 7
Create form with checkbox les that expand and collapse sections of the form? 0
Problem with Pasting into Filtered Fields 2
Excel 2007 compatibility issue - speed between cells 2
Applying function after filter is applied 4
Excel 2007 - copying filtered data to another workbook 1
Fill Series Calculations with Autofilter ON 0

Top