Formula Errors

Fix #VALUE! Errors in the Excel 2016 Calendar Template

Jason MillerJason Miller Nov 20, 2026 868 views

Question details

The user needs to resolve #VALUE! errors in the date formulas of the default Excel 2016 calendar template.

Fix #VALUE! Errors in the Excel 2016 Calendar Template
Product
Microsoft Excel 2016
Device & OS
Windows; version not provided
Scenario
Opening the default calendar template in Excel 2016.
Observed behavior
Date formulas display #VALUE! errors in Excel, although the calendar appears correctly in the File Explorer preview.
Before you start

Close Excel and other Office apps before starting the repair. Make sure you have an internet connection for Online Repair.

Solution 1Recommended

Run an Online Repair of Microsoft Office

Use Online Repair to address a possible Office installation issue, then test the calendar template again.

1
Open installed apps

Open Windows Settings and select Apps. Find Microsoft Office 2016 in the installed apps list.

2
Start the repair

Select Microsoft Office 2016, choose Modify or Change, and select Online Repair.

3
Complete the repair

Select Repair and follow the prompts until the process finishes.

4
Test the calendar

Reopen Excel 2016 and open the calendar template again. Check whether the date formulas still show #VALUE!.

Run an Online Repair of Microsoft Office
About the preview: A correct File Explorer preview does not confirm that the formulas will calculate correctly when the workbook opens in Excel.
Free Microsoft Office alternative

Open Calendar Workbooks with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easy to move existing workbooks. It does not repair the Excel installation.

Open and edit calendar workbooks in WPS SpreadsheetsCompatible with Microsoft Excel XLSX and XLS formatsFamiliar spreadsheet interface for an easier transitionFree, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the calendar look correct in File Explorer but show errors in Excel?

File Explorer may display a saved preview rather than recalculating the workbook. Open the template in Excel to check the current formula results.

Where can I find Online Repair for Office 2016?

In Windows Settings, go to Apps, select Microsoft Office 2016, and choose Modify or Change. Then select Online Repair.

What should I do if Online Repair does not fix the calendar?

If the errors persist, consider reinstalling Office 2016. First confirm that you have the installer and the account or product key needed for activation.

Can WPS Office repair my Excel 2016 installation?

No. Use Microsoft Office Online Repair for the installation. WPS Spreadsheets is an alternative for opening and editing compatible Excel workbooks, but template behavior may differ.