Error Exporting Grids to Excel - "Excel cannot open the file"
We are on tools 9.2.6.3. For some time now we have seen sporadic issues with users unable to open Excel files exported from grids. We think, but are not certain, that this would be related to certain Windows or Office updates being installed. We would clear Edge cache on the effected PC and then the export files would open; issue was resolved on that PC.
The specific error comes inside Excel when opening the exported file -- "Excel cannot open the file Book1.xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."