Question

After export to excel, file is always opened in compatibility mode. Is it problem of Pega or Excel ?

We have export to excel button in reports. Once we click on it, the report is saved in excel format.

Now when excel file is opened it is opened in compatability mode, so we have to 'save as' it again to see that.

(Pega Version 7.1.7 // Excel version - Excel 2016 )

Is this problem from Pega or Excel ??

Please suggest.

Thanks.

***Edited by Moderator Marissa to update platform capability tags****

Comments

Keep up to date on this post and subscribe to comments

September 18, 2018 - 2:48am

Also would like to add, the first exported excel is of large size, when we 'save as' it to excel workbook format, its size is reduced. So why not it can be of smaller size in first export only.

Thanks

September 26, 2018 - 5:50am

Can you please try the same use case in different machines and let us know the outcome. I will also try the same at my end and let you know.

September 26, 2018 - 6:38am

Hi Rachit,

Yes the scenario is same for all the users and from different machines.

Could you pls confirm , whether its Pega default feature, as the excel is being generated using Pega's inbuilt activity.

Pls confirm soon, so I can communicate this to the client.

Thanks,

Mayank Mishra

 

September 26, 2018 - 7:57am
Response to mayankm5528

I will be checking this and will get back to you as soon as possible.

Pega
September 26, 2018 - 3:36pm

Hi 

Thanks for posting on PSC.

I think we have to enable Check compatibility when saving this workbook box.

Kindly look into the below link which might be helpful.

https://support.office.com/en-ie/article/save-an-excel-workbook-for-compatibility-with-earlier-versions-of-excel-169a0336-965b-4430-8554-4e7b5db79947

Regards,

Hepsi

 

September 27, 2018 - 5:14am
Response to komah

Hi,

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.

Thanks,

Mayank

July 22, 2019 - 11:09am

@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.

 

Mod
July 22, 2019 - 12:46pm
Response to PrachiD5

Hello!

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.

Thanks,

Lochana | Community Moderator | Pegasystems Inc.