When using the RMB option Output to export selected lines to Excel produces a message when Excel opens ‘Error cannot open open the file ‘CustomerAnalysis 210818-102120.xlsx’ because the the file format or the file extension is not valid, Verify that the file has not been corrupted and that the file extension matches the format of the file. Click OK and excel is populated with the selected data. If exported as .xls the message return is slightly different ‘The File format and extension of CustomerAnalysis 210818-103355.xls’ don’t match. The file may be corrupted or unsafe. Unless you trust the source don’t open it. Di you want to open it anyway?
Best answer by Adam Bereda
View original