My users adore Business Central's and NAV's "Send to Excel" features, but they have a request and I have no idea how to respond.
Some pages output a file in "XML Spreadsheet 2003" format, while other pages send their data to Excel in a standard.xlsx formatted file. We're looking for a way to manage which format is used for specific pages because the XML format is actually preferred for some purposes. But I can't for the life of me figure out whether we can influence this or what factors determine which format will be used.
Can anyone provide us with some advice?
No We cannot modify excel file format