Fix Microsoft Project Summary Tasks Showing #### for Duration and Percent Complete
Question details
The user needs to display Duration and Percent Complete values correctly on Microsoft Project summary tasks.

- 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.
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.
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.
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.
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.
Check the affected summary tasks in the reopened project, then compare their dates, durations, percent complete values, and formatting with the original MPP file.
If the values display correctly and the schedule checks out, choose File > Save As and save the reopened project as a new MPP file.

Check column widths and compare Project desktop versions
Rule out a display-width issue and look for a client-specific problem when the schedule appears correctly elsewhere.
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.

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.




