A Verification Needed. Crash Excel with Advanced Filter/Cond Format

[LennyJo]

Can you verify/comment on this? I have found Excel crashes when Advanced
Filter is ran from a sheet other than the data list sheet and any of the
list labels are conditionally formatted. This procedure works fine as long
as a list label is not conditional formatted, even if the data is
conditional formatted. It also works regardless of list labels being
conditional formatted as long as the extraction is made to the data list
sheet. I've replicated this in v2002 and v2000.

Here's a simple test to replicate the crash...

In a new workbook...

Set up a simple data list on Sheet1...
A1: ID
A2: ID1
A3: ID2
B1: Data
B2: 1
B3: <empty>
C1: Name
C2: Tom
C3: Tom


Conditional Format A1...
(whatever)
i.e., Cell Value Is Not Equal to ="" Pattern=gray


Set up a simple criteria area on Sheet2...
A1: Data
A2: 1
B1: Name
B2: Tom

Activate Sheet2 and run Advanced Filter...
Action: Copy to another location.
List Range: Sheet1!$A$1:$C$3
Criteria Range: Sheet2!$A$1:$B$2
Copy to: Sheet2!$A$10

Does it crash?

Thanks,
LennyJo

 

[Dave Peterson]

It crashed xl2002 for me, too.

Can you verify/comment on this? I have found Excel crashes when Advanced
Filter is ran from a sheet other than the data list sheet and any of the
list labels are conditionally formatted. This procedure works fine as long
as a list label is not conditional formatted, even if the data is
conditional formatted. It also works regardless of list labels being
conditional formatted as long as the extraction is made to the data list
sheet. I've replicated this in v2002 and v2000.

Here's a simple test to replicate the crash...

In a new workbook...

Set up a simple data list on Sheet1...
A1: ID
A2: ID1
A3: ID2
B1: Data
B2: 1
B3: <empty>
C1: Name
C2: Tom
C3: Tom

Conditional Format A1...
(whatever)
i.e., Cell Value Is Not Equal to ="" Pattern=gray

Set up a simple criteria area on Sheet2...
A1: Data
A2: 1
B1: Name
B2: Tom

Activate Sheet2 and run Advanced Filter...
Action: Copy to another location.
List Range: Sheet1!$A$1:$C$3
Criteria Range: Sheet2!$A$1:$B$2
Copy to: Sheet2!$A$10

Does it crash?

Thanks,
LennyJo