Others

Fix an MS Project Filter Showing Inactive Deliverables

Chanuka GeekiyanageChanuka Geekiyanage Nov 22, 2026 868 views

Question details

The user needs a Microsoft Project filter that shows only active tasks with specified deliverable numbers.

Fix an MS Project Filter Showing Inactive Deliverables
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the filter

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.

2
Correct the criteria

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.

3
Apply and test

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.

Apply the Active condition to every deliverable match
Check how your editor handles criteria: The expressions above describe the required logic; they are not necessarily text to paste into a filter value field. Grouping options and evaluation behavior can vary by Project version.
Free Microsoft Office alternative

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.

Filter exported task lists in WPS Spreadsheets.Open and edit Microsoft Excel XLSX files.Use a familiar spreadsheet interface for everyday work.Work with a free, lightweight Office suite.
microsoft office alternative - wps office

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.