Forum Discussion

3cats's avatar
3cats
Copper Contributor
Dec 08, 2021

What version of Excel was used?

Is there a way to check a workbook for the version of Excel that was used when it was built?   I know how to check compatibility.  I have a workbook which I have build over time.  It has a lot of f...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Dec 11, 2021

3cats 

Tip:

Since an XML-based file format has been used since Microsoft Office 2007, you have another option here:

1. Take an XLSX (or XLSM) file and change the file extension to .zip.

2. Then open this zip archive and open the app.xml file in the "docProps" folder.

4. In this you will find the entry "AppVersion".

In the inserted file it would be: officeDocument / 2006 / extended-properties

 

The whole thing can certainly be done programmatically - but the source code should be a little longer, so not really easy either.

 

In the inserted Excel file you will find a small VBA code to recognize the Excel version. Is only up to Excel 2019, not fully tested (as I said, on the fast :), but it works for my Excel 2016.

 

File formats that are supported in Excel

Note: Whenever you save a file in another file format, some of its formatting, data, and features might not be transferred.

Excel formatting and features that are not transferred to other file formats

Save an Excel workbook for compatibility with earlier versions of Excel

 

Hope I was able to help you with this tip / information / link.

 

NikolinoDE

I know that I don't know (Socrates)

 

Resources