Others

Why Microsoft Project SPI and CPI Do Not Reset to 1 After a New Baseline

Muhammad TalhaMuhammad Talha Nov 13, 2026 868 views

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.

Why Microsoft Project SPI and CPI Do Not Reset to 1 After a New Baseline
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

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.

Solution 1Recommended

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.

1
Open Microsoft Project Options

Open the project in Microsoft Project and click the File tab.

2
Go to Advanced Options

Select Options, then choose Advanced in the left pane.

3
Locate Earned Value Settings

Scroll to the Earned Value section and find Baseline for Earned Value calculations.

4
Select the New Baseline

Choose the baseline field where the new plan was saved, such as Baseline, Baseline 1, or Baseline 2.

5
Apply and Review SPI/CPI

Click OK and review the SPI and CPI columns in the task view.

Set the Correct Baseline for Earned Value Calculations
Earned value baseline aligned: After selecting the correct baseline, SPI and CPI will recalculate based on the new plan and current task progress.
Free Microsoft Office alternative

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.

Work with project schedule exports in Excel to track SPI and CPI outside Microsoft ProjectFull Microsoft Office format compatibility for .xlsx, .docx, and .pptx filesFamiliar ribbon interface and shortcuts for a seamless migration from Microsoft OfficeFree, lightweight Office suite that avoids expensive Microsoft Project and Office subscriptions
microsoft office alternative - wps office

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.