Why Microsoft Project SPI and CPI Do Not Reset to 1 After a New Baseline
Question details
The user needs to diagnose why Microsoft Project SPI and CPI are not resetting to 1 after creating a new baseline and how to align earned value settings and task progress.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A project manager saved a new baseline in Microsoft Project and expects the SPI and CPI earned value fields to reset to 1 for the updated plan.
- Observed behavior
- SPI and CPI remain at zero or a previous value even though the project options appear correct.
Before you start, verify which baseline field such as Baseline, Baseline 1, or Baseline 2 contains the new plan, and make sure you can access File > Options > Advanced in Microsoft Project.
Set the Correct Baseline for Earned Value Calculations
Use this solution first when SPI and CPI show zero or an unexpected value after saving a new baseline; it aligns the earned value calculation with the baseline that contains the new plan.
Microsoft Project calculates SPI and CPI against the baseline selected in Earned Value options. If the selection still points to an older baseline, the fields will not reset as expected.
Open the project in Microsoft Project and click the File tab.
Select Options, then choose Advanced in the left pane.
Scroll to the Earned Value section and find Baseline for Earned Value calculations.
Choose the baseline field where the new plan was saved, such as Baseline, Baseline 1, or Baseline 2.
Click OK and review the SPI and CPI columns in the task view.

Verify Task Progress, Costs, and Resource Assignments
Use this solution if the baseline is correct but SPI and CPI still remain zero or do not move to 1.
Use WPS Office to Handle Project Data Without Microsoft Project
WPS Office does not open or fix Microsoft Project .mpp files, but it is a free, lightweight Office alternative that opens and edits Word, Excel, and PowerPoint files with a familiar ribbon interface. Export project data from Microsoft Project to Excel and continue tracking or reporting in WPS Office seamlessly.

Frequently Asked Questions
Why are SPI and CPI still 0 after saving a new baseline in Microsoft Project?
Usually the earned value baseline is not set to the baseline that contains your new plan, or tasks have no actual progress or costs. Check File > Options > Advanced and verify the Baseline for Earned Value calculations setting.
Does Microsoft Project reset SPI and CPI to 1 automatically after a new baseline?
SPI and CPI equal 1 only when earned value equals planned value and actual cost equals earned value. After re-baselining, the values recalculate based on the selected baseline and current progress, so they may not be exactly 1 until progress is updated.
How do I change the baseline used for SPI and CPI calculations?
Go to File > Options > Advanced, find the Earned Value section, choose the correct baseline in Baseline for Earned Value calculations, and click OK.
Can I use WPS Office to open Microsoft Project .mpp files?
No, WPS Office does not open .mpp files. You can export project data to Excel from Microsoft Project and then use WPS Spreadsheets to view or analyze the exported data.
Which Microsoft Project fields show SPI and CPI?
SPI and CPI are earned value fields available in task views. You can insert them by right-clicking a column header, choosing Insert Column, and selecting SPI or CPI from the field list.




