Excel

How to open Excel 2016 files in Excel 2013

by Jeffrey Collins
3 min read

Opening Excel 2016 files in Excel 2013 can be essential for users who need to access or edit documents created in a newer version of Excel. This task is useful for ensuring compatibility with different systems or for collaborating with colleagues using older versions of the software. Below is a comprehensive guide on how to do this seamlessly.

Key Takeaways

  • Excel 2016 uses a newer file format (.xlsx) with features not available in Excel 2013.
  • You can save an Excel 2016 file in a compatible format that Excel 2013 can read.
  • Understanding how to manage different Excel file versions is crucial for effective data collaboration.

Step-by-Step Guide

  1. Open Excel 2016: Start by launching Excel 2016 on your computer.

  2. Open the file: Go to File > Open, and select the Excel 2016 file that you want to access.

  3. Convert the File: Once the file is open, navigate to File > Save As.

  4. Select the Save Location: Choose the location where you want to save your file.

  5. Choose Compatible Format: Under the Save as type dropdown menu, select Excel Workbook (.xlsx). Alternatively, you can choose Excel 97-2003 Workbook (.xls) if you want the widest compatibility.

  6. Save the File: Click Save. If you opted for the .xls format, some features may be lost, so ensure that this is acceptable for your needs.

  7. Open in Excel 2013: Now, open Excel 2013 and go to File > Open to find the newly saved file.

  8. Review and Edit: Once opened, review your document. Check if any features are missing due to compatibility issues.

See also  Chart colors don’t work in Microsoft Excel

Example: If your original Excel 2016 file included a VLOOKUP formula like =VLOOKUP(A2, B2:D10, 2, FALSE), ensure it still works in Excel 2013 without any issues.

Expert Tips

  • Check for Compatibility: Use the Compatibility Checker in Excel 2016 under File > Info > Check for Issues. This tool helps identify any features that won’t work in Excel 2013.

  • Consider Saving in .xlsm Format: If your 2016 file contains macros, consider saving it as an *Excel Macro-Enabled Workbook (.xlsm)** to maintain those functionalities while still being accessible in Excel 2013.

  • Regular Backups: Always back up your files before saving in a different format, especially if you’re converting to a version that may not support newer features.

Conclusion

By following the steps outlined in this guide, you can successfully manage and open Excel 2016 files in Excel 2013. Make sure to save your files in compatible formats and regularly check for features that may not transfer correctly. With these techniques, you’ll enhance your efficiency and collaboration using Microsoft Excel across different versions.

About the author

Jeffrey Collins

Jeffrey Collins

Jeffery Collins is a Microsoft Office specialist with over 15 years of experience in teaching, training, and business consulting. He has guided thousands of students and professionals in mastering Office applications such as Excel, Word, PowerPoint, and Outlook. From advanced Excel functions and VBA automation to professional Word formatting, data-driven PowerPoint presentations, and efficient email management in Outlook, Jeffery is passionate about making Office tools practical and accessible. On Softwers, he shares step-by-step guides, troubleshooting tips, and expert insights to help users unlock the full potential of Microsoft Office.

View all posts

You may also like