The Mode function in Microsoft Excel is classified as a compatibility function and recommends using the MODE.MULT and MODE.SNGL instead.

This tutorial will show you how to remove disable or turn off the Compatibility Mode in Microsoft Excel. Without Compatibility Mode, some documents may display incorrectly.