The button ‘Open in Excel’ is available in several tables, however it creates an excel sheet with all table columns. It would be great to be able to open an excel sheet with only the visible columns of a table, sorted in the order defined on the list.
Comments
The Business Central online help states on Open in Excel. "With this action, Excel respects any filters on the page that limit the records shown. The Excel workbook will contain the same rows and columns that appear on the page in Business Central". Viewing and Editing in Excel From Business Central (contains video) - Business Central | Microsoft Learn
So, the online help is incorrect, or the feature is not working as designed. Can this please be addressed?
Category: Office Integration
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team