Advanced Filter in Shared Workgroup?

[Three20Three]

Is there anyway to get an advanced filter to work in a
shared workbook? If not, is there an alternative to
advanced filtering that I could use?

Thanks,
Three20Three

 

[Debra Dalgleish]

You could filter the results to a different workbook:

1. Create a new blank workbook
2. Choose Data>Filter>Advanced Filter
3. Select Copy to another location
4. Activate the shared workbook, and select the list range
5. Select the criteria range (in either workbook)
6. Select a 'Copy to' location
7. Click OK