@RISK: Filter Button Gray in Excel

Filter tasks in @RISK projects in MS Project, not Excel; use Risk Categories or Parameter Entry Table to group tasks for similar treatment.

Title

Answer

Applies to: @RISK 6.x and Up, Professional and Industrial Editions

Issue: Excel’s filter button is grayed out when trying to filter tasks from an @RISK project simulation.

Resolution:

Set your filters directly in Microsoft Project, not Excel.
If filtering is needed for grouping tasks for similar treatment, consider using:
- Risk Categories
- Parameter Entry Table

References:

@RISK: Filtering Tasks in Projects

URL Name

filter-button-gray-in-excel

Related Articles