A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Good day Raymond,
Based on the Microsoft documentation, the export process involves selecting Send to > Microsoft Excel Document (data only), after which Business Central generates an Excel workbook and downloads it to your device.
If you export a report using Share > Open in Excel and OneDrive integration isn't configured for Business Central, the workbook is downloaded to your device and needs to be opened manually in Excel desktop or Excel for the web.
You can ask a few colleagues to try the same action and check whether they experience the same behavior. If the issue affects multiple users, please contact your IT administrator and ask them to verify whether OneDrive integration is configured for Business Central. For reference, you can share this article with them: Managing OneDrive Integration with Business Central - Business Central | Microsoft Learn
Note: In case you do not know who is your IT admin, kindly refer to this article: How do I find my Microsoft 365 admin? - Microsoft Support
Additionally, this forum category primarily focuses on Office 365 products and your concern is related to Dynamics 365 Business Central. I want to ensure you receive the most accurate and effective assistance. For this reason, I recommend posting your question in the Microsoft Dynamics 365 Community, where you can benefit from additional perspectives and connect with other users who may have encountered similar situations and are willing to share their experiences. To help you receive better and more accurate assistance, I am guiding you to the appropriate resource.
I hope this information is helpful. Thank you once again for your precious time and engagement.
If the answer is helpful, please click "Yes" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".
Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.