Recover Missing Cost and Resource Data in Microsoft Project
Question details
Recover missing hourly rates and initials and investigate unexpected resources in Microsoft Project files.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Project files stored in a company's SharePoint were opened after a period of inactivity.
- Observed behavior
- Some files have missing cost and resource details, unexpected resources, or a date of 1601-01-01. None of the available SharePoint versions checked contained the missing cost data.
Identify the affected Project files and their SharePoint or OneDrive locations. Record which rates, initials, resources, and dates are incorrect so you can compare versions and provide details to support.
Check version history and save a separate copy
Use this approach to look for an earlier file version that still contains the missing data.
In SharePoint or OneDrive, locate the affected file, select its More options menu, and choose Version history.
Open or download relevant earlier versions and check their resource names, initials, and hourly rates in Microsoft Project.
If a version contains the missing data, use the Version history menu to restore it, or save a separate copy under a different name and location.
If the current file opens in Microsoft Project, use File > Save As to save a copy under a different name and location for investigation.

Ask your administrator and Microsoft Support to investigate
Use this option when available versions do not contain the missing cost or resource data.
Track Project Resources in WPS Spreadsheets
WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar interface and support for common Microsoft Office formats. Use a spreadsheet to track exported resource information; WPS does not restore missing Microsoft Project data.

Frequently Asked Questions
Where can I find older versions of a Project file?
In SharePoint or OneDrive, select the file's More options menu and choose Version history. Open or download relevant versions to check their contents.
What if none of the available versions contain the missing rates?
Contact your organization's Microsoft 365 or SharePoint administrator and ask them to open a Microsoft Support ticket. Include the file locations and the versions you already checked.
Does saving the file under a new name restore missing data?
No. In Microsoft Project, File > Save As creates a separate copy of the current file, but it does not recover fields that are already missing.
What should I do about the 1601-01-01 date?
Record where the date appears and include it in the information you give your administrator or Microsoft Support. The date alone does not establish the cause or a recovery method.
Can WPS Office recover missing data from a Microsoft Project file?
No. Check SharePoint or OneDrive version history and contact Microsoft Support for recovery. WPS Spreadsheets can instead help you track resource data in an Excel-compatible file.




