Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Problem with Filter
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Problem with Filter
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 " wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Problem with Filter
Description of bug and workaround he
http://www.asap-utilities.com/blog/i...m-with-copying -filtered-data-in-excel-2007-workaround/ " wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autosum with filter excel 2007 | Excel Discussion (Misc queries) | |||
Auto Filter in EXCEL 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Filter in Column | Excel Worksheet Functions | |||
Excel 2007 (Beta) Auto Filter | Excel Worksheet Functions | |||
filter options in excel 2007 | Excel Discussion (Misc queries) |