At the end, the solution is to update the excel 2019 to the latest version and that solved the problem. Excel Direct is exporting to "xlsx" format once again.