{"id":2002,"date":"2025-02-20T05:42:22","date_gmt":"2025-02-20T05:42:22","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?p=2002"},"modified":"2026-10-31T12:14:33","modified_gmt":"2026-10-31T12:14:33","slug":"excel-compatibility-version-file-format-problems","status":"publish","type":"post","link":"https:\/\/www.exceldepartment.com\/en\/excel-compatibility-version-file-format-problems\/","title":{"rendered":"Excel Compatibility: Solve Version and File Format Problems"},"content":{"rendered":"<\/p>\n

Your Excel file works perfectly on your computer. You send it to a colleague. It opens, but formulas show #NAME?, charts are missing, or the file is read-only. Compatibility problems.<\/p>\n

This guide shows you how to identify and solve compatibility problems between Excel versions, operating systems and file formats. You will learn to check compatibility before sharing and to fix problems when they occur.<\/p>\n

For general troubleshooting, see the Excel troubleshooting guide<\/a>. For other problems, read common Excel problems<\/a>.<\/p>\n

Excel versions and functions<\/h2>\n

Version history<\/h3>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n
Version<\/th>\nRelease year<\/th>\nKey features<\/th>\nLimitations<\/th>\n<\/tr>\n<\/thead>\n
Excel 2003<\/td>\n2003<\/td>\nBasic functions<\/td>\nMax 65,536 rows, 256 columns, .xls format<\/td>\n<\/tr>\n
Excel 2007<\/td>\n2007<\/td>\nRibbon interface, .xlsx<\/td>\nMax 1,048,576 rows, 16,384 columns<\/td>\n<\/tr>\n
Excel 2010<\/td>\n2010<\/td>\nSparklines, slicers<\/td>\n\u2014<\/td>\n<\/tr>\n
Excel 2013<\/td>\n2013<\/td>\nPower Query, Power Pivot<\/td>\n\u2014<\/td>\n<\/tr>\n
Excel 2016<\/td>\n2016<\/td>\nPower BI integration<\/td>\n\u2014<\/td>\n<\/tr>\n
Excel 2019<\/td>\n2019<\/td>\nCONCAT, IFS<\/td>\n\u2014<\/td>\n<\/tr>\n
Excel 365<\/td>\nOngoing<\/td>\nDynamic arrays, XLOOKUP, FILTER<\/td>\nFunctions are added continuously<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Problem: Functions that do not exist in older versions<\/h3>\n

Excel 365-exclusive functions:<\/strong> – XLOOKUP – FILTER – UNIQUE – SORT – SEQUENCE – RANDARRAY<\/p>\n

What happens:<\/strong> If you use =XLOOKUP(...)<\/code> in Excel 365 and open the file in Excel 2016 \u2192 #NAME?<\/p>\n

Solution: Use older equivalents<\/h3>\n

XLOOKUP \u2192 INDEX\/MATCH<\/strong><\/p>\n

Excel 365:<\/p>\n

=XLOOKUP(E2;A:A;B:B;"Ej funnen")<\/code><\/pre>\n
Compatible with all versions:<\/p>\n
=OMFEL(INDEX(B:B;MATCH(E2;A:A;0));"Ej funnen")<\/code><\/pre>\n
FILTER \u2192 Advanced filter or pivot table<\/strong><\/p>\n
Excel 365:<\/p>\n
=FILTER(A2:C100;B2:B100="Syd")<\/code><\/pre>\n
Compatible: Use Data \u2192 Advanced Filter (manually) or a pivot table.<\/p>\n
Check compatibility before sharing<\/h3>\n<\/p>\n
Step 1: Use the compatibility checker<\/strong><\/p>\n
    \n
  1. File<\/code> \u2192 Info<\/code><\/li>\n
  2. Check for Issues<\/code> \u2192 Check Compatibility<\/code><\/li>\n
  3. Select the versions to check against<\/li>\n
  4. Excel lists all problems<\/li>\n<\/ol>\n
    Example results:<\/strong> – \u201cSome formulas in this workbook use functions that are not available in earlier versions of Excel\u201d – \u201cThis workbook contains data in cells outside the row and column limits of earlier versions\u201d – \u201cSome charts contain effects that are not supported\u201d<\/p>\n
    Step 2: Fix the problems<\/strong><\/p>\n
    For each problem: – Click \u201cFind\u201d to jump to the problem – Fix it manually or accept the limitation<\/p>\n
    Save in compatibility mode<\/h3>\n
    File \u2192 Save As \u2192 Select \u201cExcel 97-2003 (.xls)\u201d<\/strong><\/p>\n
    Advantages:<\/strong> – Opens in all Excel versions<\/p>\n
    Disadvantages:<\/strong> – Max 65,536 rows – Max 256 columns – Newer functions do not work – Larger file size<\/p>\n
    Recommendation:<\/strong> Use .xlsx and avoid new functions instead.<\/p>\n
    File formats: .xls vs .xlsx vs .xlsm vs .xlsb<\/h2>\n<\/p>\n
    Format overview<\/h3>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
    Format<\/th>\nYear<\/th>\nDescription<\/th>\nUse<\/th>\n<\/tr>\n<\/thead>\n
    .xls<\/strong><\/td>\n1997-2003<\/td>\nBinary format<\/td>\nLegacy compatibility<\/td>\n<\/tr>\n
    .xlsx<\/strong><\/td>\n2007+<\/td>\nXML-based, compressed<\/td>\nStandard for modern files<\/td>\n<\/tr>\n
    .xlsm<\/strong><\/td>\n2007+<\/td>\n.xlsx with macros<\/td>\nFiles with VBA code<\/td>\n<\/tr>\n
    .xlsb<\/strong><\/td>\n2007+<\/td>\nBinary, compressed<\/td>\nLarge files, faster<\/td>\n<\/tr>\n
    .csv<\/strong><\/td>\n\u2014<\/td>\nComma-separated values<\/td>\nData exchange, no formatting<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    Problem: \u201cExcel cannot open the file because the file extension is not valid\u201d<\/h3>\n
    Cause:<\/strong> The file extension does not match the actual content.<\/p>\n
    Example:<\/strong> The file is named \u201cdata.xlsx\u201d but is actually in .xls format.<\/p>\n
    Solution:<\/strong> 1. Rename the file from .xlsx to .xls 2. Try to open it 3. If it works: Save as .xlsx again<\/p>\n
    Problem: Macros do not work<\/h3>\n
    Cause:<\/strong> The file was saved as .xlsx (macros are not allowed).<\/p>\n
    Solution:<\/strong> Save as .xlsm instead: 1. File \u2192 Save As 2. Select \u201cExcel Macro-Enabled Workbook (.xlsm)\u201d<\/p>\n
    When to use which format<\/h3>\n
    Use .xlsx if:<\/strong> – Standard file without macros – It will be shared with others – It will be stored long term<\/p>\n
    Use .xlsm if:<\/strong> – It contains VBA code\/macros<\/p>\n
    Use .xlsb if:<\/strong> – The file is over 10 MB – You need fast opening\/saving – It does not need to be shared outside the organisation<\/p>\n
    Use .xls if:<\/strong> – It must open in Excel 2003 or older – Otherwise: Avoid<\/p>\n
    Use .csv if:<\/strong> – Exporting to other systems – Database import – No formatting\/formulas needed<\/p>\n
    Windows vs Mac<\/h2>\n
    Excel on Mac differs from the Windows version.<\/p>\n
    Functional differences<\/h3>\n
    Missing on Mac:<\/strong> – Some add-ins and ActiveX controls – The Visual Basic Editor has limitations – Power Query (limited in older Mac versions) – Some keyboard shortcuts differ<\/p>\n
    Keyboard shortcuts Mac vs Windows:<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n
    Function<\/th>\nWindows<\/th>\nMac<\/th>\n<\/tr>\n<\/thead>\n
    Copy<\/td>\nCtrl+C<\/td>\nCmd+C<\/td>\n<\/tr>\n
    Paste<\/td>\nCtrl+V<\/td>\nCmd+V<\/td>\n<\/tr>\n
    Save<\/td>\nCtrl+S<\/td>\nCmd+S<\/td>\n<\/tr>\n
    Find<\/td>\nCtrl+F<\/td>\nCmd+F<\/td>\n<\/tr>\n
    Open VBA<\/td>\nAlt+F11<\/td>\nOption+F11 (limited)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    Problem: VBA does not work on Mac<\/h3>\n
    Why:<\/strong> Some Windows API calls do not work on Mac.<\/p>\n
    Example:<\/strong><\/p>\n
    Declare Function GetUserName Lib "advapi32.dll" ...<\/code><\/pre>\n
    This only works on Windows.<\/p>\n
    Solution:<\/strong> Use conditional compilation:<\/p>\n
    #If Mac Then\r\n    ' Mac-version av kod\r\n#Else\r\n    ' Windows-version av kod\r\n#End If<\/code><\/pre>\n
    Problem: File paths<\/h3>\n
    Windows:<\/strong><\/p>\n
    filv\u00e4g = "C:\\Users\\Anv\u00e4ndare\\Dokument\\fil.xlsx"<\/code><\/pre>\n
    Mac:<\/strong><\/p>\n
    filv\u00e4g = "\/Users\/Anv\u00e4ndare\/Documents\/fil.xlsx"<\/code><\/pre>\n
    Solution:<\/strong> Use relative paths or detect the OS:<\/p>\n
    #If Mac Then\r\n    filv\u00e4g = "\/Users\/" & Environ("USER") & "\/Documents\/fil.xlsx"\r\n#Else\r\n    filv\u00e4g = "C:\\Users\\" & Environ("USERNAME") & "\\Documents\\fil.xlsx"\r\n#End If<\/code><\/pre>\n
    Problem: The file opens as read-only<\/h2>\n
    Cause 1: Open on another computer<\/h3>\n
    The file is open by someone else (on a network drive or SharePoint).<\/p>\n
    Solution:<\/strong> – Wait until the other user closes it – Or open it read-only and save a copy<\/p>\n
    Cause 2: File marked as read-only<\/h3>\n
    Windows:<\/strong> 1. Right-click the file \u2192 Properties 2. Clear \u201cRead-only\u201d 3. OK<\/p>\n
    Mac:<\/strong> 1. Right-click the file \u2192 Get Info 2. Under \u201cSharing & Permissions\u201d \u2192 Unlock 3. Change the permission to \u201cRead & Write\u201d<\/p>\n
    Cause 3: OneDrive\/SharePoint sync error<\/h3>\n
    Solution:<\/strong> 1. Open the file directly in a web browser (Office Online) 2. Or: Right-click the OneDrive icon \u2192 Settings \u2192 Unlink and link again<\/p>\n
    Cause 4: Network permissions<\/h3>\n
    Solution:<\/strong> Contact the IT department to have the permissions changed.<\/p>\n
    Problem: Formatting looks different<\/h2>\n
    Cause: Missing fonts<\/h3>\n
    If the file uses fonts that are not installed on the computer, they are replaced.<\/p>\n
    Solution:<\/strong> – Use standard fonts (Calibri, Arial, Times New Roman) – Or: Embed fonts (File \u2192 Options \u2192 Save \u2192 \u201cEmbed fonts in the file\u201d)<\/p>\n
    Warning:<\/strong> Embedding fonts increases the file size and may breach licence terms.<\/p>\n
    Cause: Different screen resolution<\/h3>\n
    The file was created on a 4K screen and opened on a laptop with a lower resolution.<\/p>\n
    Solution:<\/strong> – Use percentage scaling (Page Layout \u2192 Scale) – Avoid pixel-based positions<\/p>\n
    Cause: Different Excel versions render differently<\/h3>\n
    Solution:<\/strong> – Export as PDF for an exact appearance – Or: Accept small differences<\/p>\n
    Best practices for compatibility<\/h2>\n
    1. Use standard functions<\/h3>\n
    Avoid Excel 365-exclusive functions if the file is shared with older versions.<\/p>\n
    Check function compatibility:<\/strong> – Microsoft’s documentation lists which version each function requires<\/p>\n
    2. Test on the target platform<\/h3>\n
    Before an important presentation or sharing: – Open the file on the same type of computer\/Excel version as the recipient has – Or: Ask the recipient to test and give feedback<\/p>\n
    3. Always save as .xlsx<\/h3>\n
    .xls is obsolete. If the recipient has Excel 2007 or later (most do), use .xlsx.<\/p>\n
    4. Document the Excel version<\/h3>\n
    Add a comment in the workbook: \u201cRequires Excel 2016 or later\u201d or \u201cCompatible with all versions\u201d<\/p>\n
    5. Consider PDF for final documents<\/h3>\n
    If the recipient only needs to read (not edit): – File \u2192 Save As \u2192 PDF – Guarantees the same appearance everywhere<\/p>\n
    6. Use cloud-based solutions<\/h3>\n
    OneDrive\/SharePoint + Excel Online: – Same version for everyone – Collaborate in real time – No compatibility problems<\/p>\n
    When you need professional help<\/h2>\n
    Contact Excel Department if:<\/strong><\/p>\n