Let's look into the software compatibility, bcswd.
Before we start exporting let's check the system requirements compatible for QuickBooks Desktop Pro 2018. Just open the Software compatibility section under
QuickBooks Pro/Premier 2019 and Enterprise 19.0 of this article: System requirements for QuickBooks 2019 and Enterprise Solutions 19.0.
Then, we can try to make some updates within Excel and QuickBooks again to get the most up-to-date fixes. Then, we can start exporting data in to Excel.
I'll be here if you need anything else. You keep safe always and have a great day!