Others

Fix Microsoft Project Summary Tasks Showing #### for Duration and Percent Complete

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

The user needs to display Duration and Percent Complete values correctly on Microsoft Project summary tasks.

Fix #### in Microsoft Project Summary Task Duration and Percent Complete
Product
Microsoft Project desktop client and Project Online
Device & OS
not provided
Scenario
A project schedule is opened in the desktop client and compared with the same schedule in Project Online and other Project versions.
Observed behavior
Some summary tasks show #### for Duration and Percent Complete in the desktop client, although dates and scheduling appear correct and the values display normally in Project Online.
Before you start

Open the affected schedule in Microsoft Project and identify which summary tasks and columns show ####. Keep the original MPP file available so you can compare it with any copy or XML file you create.

Solution 1Recommended

Save the schedule as XML and reopen it in Project

Use an XML round trip to test whether file corruption or excess file data is contributing to the display problem.

Reopening the schedule from XML may remove custom formatting or change other project information, so check the result against the original MPP file.

1
Save an XML copy

In the affected desktop client, open the schedule and choose File > Save As. Select a location, choose XML Format in the file type list, and save the file with a new name.

2
Reopen the XML file

Choose File > Open, browse to the XML file, and open it. If Project offers an import choice, select the option to open it as a new project.

3
Compare the schedule

Check the affected summary tasks in the reopened project, then compare their dates, durations, percent complete values, and formatting with the original MPP file.

4
Save the restored project

If the values display correctly and the schedule checks out, choose File > Save As and save the reopened project as a new MPP file.

Save the schedule as XML and reopen it in Project
If the XML file will not open: Try creating the XML file again from a working Project desktop installation. If it still fails to load, use the original MPP file and investigate the desktop client or contact your Project administrator.
Free Microsoft Office alternative

Review exported project data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for easy migration. Use WPS Spreadsheets to review project data exported to a spreadsheet; it does not repair Microsoft Project or replace its scheduling features.

Review exported task durations and completion percentages in a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for a smooth transitionWork with a free, lightweight Office suite
QA img-9

Frequently Asked Questions

Does #### always mean the project schedule is corrupted?

No. First try widening the affected column by dragging the right edge of its header. If the values still show ####, compare the file in another Project version and consider testing an XML copy.

Will saving a Project file as XML preserve all formatting?

Not necessarily. Custom formatting may be lost, so reopen the XML as a new project and compare its schedule and formatting with the original MPP file before using it.

Why does the schedule look correct in Project Online but not on the desktop?

The difference may be specific to the desktop client or its version. Check File > Account > About Project for the installed build, and compare the same file in another desktop version.

What should I do if the XML file fails to load?

Create a fresh XML copy from a working Project desktop installation and try File > Open again. If it still fails, retain the original MPP file and ask your Project administrator for help.