You can resolve the quickbooks Excel could not open the data file issue on Mac by following the below-mentioned steps:
First, make sure that your Mac system is compatible with the Excel version that you are using currently.
Then, also check if the system meets the basic requirements set to work with the QuickBooks application.
Then, if the system meets both of the above requirements, then you might be having an issue with the installation of either QB or Excel.
To check if the issue lies with the Excel, you can re-register all the keys with Microsoft by reinstalling it or by simply repairing the Microsoft Office.
For the last step, check the issues with the QuickBooks installation and do a clean installation of the application if needed.