Disable Compatibility Checker in Excel in Python

MS Excel compatibility checker ensures that a file in an older format does not use the features provided by the newer Excel version. Thus, people using older versions of Excel do not face compatibility issues. While manipulating Excel files, you may need to disable the compatibility checker dynamically. To achieve it, this article shows how to enable or disable the compatibility checker for MS Excel workbooks in Python.
December 8, 2021 · 2 min · Usman Aziz