Could you confirm, whether issue is with excel or with Pega?? As I have tried changing excel settings, but when Pega is creating the excel on click of Export To Excel it is being saved in Microsoft Excel 97-2003 Worksheet.
@mayankm5528, were you able to solve this, as I am in similar situation. I am processing the data and exporting it to Microsoft Excel 97- 2003 worksheet and everything i save the excel the compatibility checker pops up which needs manual clicking, is there a way to automate or address this issue.
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of this screen and also on our Pega Support Community homepage. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.