File Format & Compatibility

Fix Excel 2016 Save As Not Creating a New File for Older Workbooks

Natalie TaylorNatalie Taylor Nov 20, 2026 869 views

Question details

The user needs Excel 2016 to create a new file when saving a workbook originally created in Excel 2013.

Fix Excel 2016 Save As Not Creating a New File for Older Workbooks
Product
Microsoft Excel 2016
Device & OS
Windows 10
Scenario
After upgrading to Office 2016, the user tries to save older workbooks under a new name.
Observed behavior
Save As does not create a new file for some workbooks created in Excel 2013, while workbooks created in Excel 2016 save normally.
Before you start

Check whether the issue affects one workbook or several, and note their file extensions. Make sure you have permission to write to a local folder such as Documents.

Solution 1Recommended

Save the Workbook Under a New Name in a Local Folder

Use a local destination and a different file name to check whether the original location, synchronization, or file format is involved.

1
Choose a local destination

Open the affected workbook in Excel, select File > Save As > Browse, and choose a local folder such as Documents.

2
Change the file name

Enter a different name in the File name box, click Save, and check the destination folder for the new file.

3
Check the file format

If the file still does not appear, try File > Save As again and select Excel Workbook (*.xlsx) in the Save as type list, then save and test the new file. If the workbook contains macros, select Excel Macro-Enabled Workbook (*.xlsm) instead.

4
Compare locations

If saving locally works but a network or synchronized folder fails, check write permissions and synchronization status for the original location. If available, you can also try File > Save a Copy.

Save the Workbook Under a New Name in a Local Folder
Excel 2013 and 2016 formats: Both versions support .xlsx files. Saving an existing .xlsx file again is a troubleshooting test, not a conversion to a different Excel 2016 format.
Free Microsoft Office alternative

Save and Edit Excel Workbooks with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel workbooks. Its format compatibility helps you move existing files into a new workflow, although it does not repair Excel's Save As feature.

Open and save workbooks using Microsoft Excel formats such as .xlsxUse Save As to create a separately named copy of a workbookWork in a familiar spreadsheet interface that makes migration easierUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Are Excel 2013 workbooks compatible with Excel 2016?

Excel 2016 supports common Excel 2013 formats, including .xlsx. If Save As fails, test a local destination and check add-ins rather than assuming every older workbook needs conversion.

How do I check whether an add-in is causing the problem?

Press Windows + R, run excel /safe, and try File > Save As. If it works, restart Excel normally and review add-ins under File > Options > Add-ins.

Why can I save locally but not to a network folder?

The destination may have restricted write permissions, a connection problem, or a synchronization issue. Check access to the original folder or ask your IT team to review it.

Should I save a workbook with macros as .xlsx?

No. To preserve macros, use File > Save As and select Excel Macro-Enabled Workbook (*.xlsm). The .xlsx format does not retain VBA macros.