Fix an MS Project Filter Showing Inactive Deliverables
Question details
The user needs a Microsoft Project filter that shows only active tasks with specified deliverable numbers.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A custom view filters tasks using several deliverable-number conditions and an Active condition.
- Observed behavior
- Inactive tasks appear in the view even though the filter includes an Active condition.
Identify the field that contains the deliverable numbers and the numbers the view should include. Note an inactive task and an active task with matching numbers so you can test the revised filter.
Apply the Active condition to every deliverable match
Correct the filter logic so an OR condition cannot include an inactive task.
The intended logic is Active = Yes AND (Deliverable = A OR Deliverable = B). The deliverable conditions must be evaluated together before the Active requirement is applied.
An equivalent expression is (Active = Yes AND Deliverable = A) OR (Active = Yes AND Deliverable = B). Use the actual deliverable field and values in place of A and B.
In Microsoft Project, open the affected view. On the View tab, open the Filter list, choose More Filters, select the custom filter, and click Edit.
In the filter definition, configure the deliverable-number alternatives as one group combined with Active = Yes using AND. If your filter editor does not offer grouping, use equivalent branches that repeat Active = Yes for each deliverable condition, and verify the result before relying on it.
Save the filter and apply it from the View tab's Filter list. Check that matching active tasks appear, while matching inactive tasks and active tasks with other deliverable numbers do not.

Review exported project data in WPS Spreadsheets
WPS Office is a free, lightweight alternative for everyday Office documents, with a familiar interface and compatibility that makes moving spreadsheet work easier. It does not fix Microsoft Project filters, but you can review project data exported to a spreadsheet.

Frequently Asked Questions
Why does my filter still show inactive tasks?
An OR condition may allow a deliverable match without also requiring Active = Yes. Edit the filter under View > Filter > More Filters and check that the Active condition applies to every deliverable alternative.
How can I check whether the corrected filter works?
Apply the filter from the View tab and compare tasks with known values. A matching active task should appear; a matching inactive task and an active task with an unselected deliverable number should not.
What if I have more than two deliverable numbers?
Include each required number as an OR alternative within the deliverable group, then combine the whole group with Active = Yes using AND. Alternatively, repeat Active = Yes in each equivalent branch and test the results.
Can WPS Office repair the Microsoft Project filter?
No. Edit the filter in Microsoft Project. WPS Spreadsheets can review task data exported to a compatible spreadsheet such as XLSX, but it does not change the Project filter.




