Fix Excel 2016 Save As Not Creating a New File for Older Workbooks
Question details
The user needs Excel 2016 to create a new file when saving a workbook originally created in Excel 2013.

- 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.
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.
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.
Open the affected workbook in Excel, select File > Save As > Browse, and choose a local folder such as Documents.
Enter a different name in the File name box, click Save, and check the destination folder for the new file.
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.
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.

Test Excel in Safe Mode and Check Add-ins
Use Safe Mode to find out whether an add-in or startup customization is interfering with Save As.
Update and Repair Office 2016
Try Office updates and repair if local saving and add-in checks do not resolve the problem.
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.

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.




