Solved: QlikView export to excel prohibition of data edit... - Qlik Community

rapovets_A2C · ‎2020-09-04

Is it possible in QlikView to allow export data to excel, but prohibit editing the data in the document itself?

Sonja_Bauernfeind · ‎2020-09-04

Do you mean editing of the Excel file that is being created?

Unfortunately, as it is a simple Excel file which the user has access to, the file can be edited. You may want to look into NPrinting and allowing users to create reports in different formats that don't allow direct modifications.

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂

View solution in original post

Sonja_Bauernfeind · ‎2020-09-04

Hello @rapovets_A2C

Do you mean editing of the Excel file that is being created?

Unfortunately, as it is a simple Excel file which the user has access to, the file can be edited. You may want to look into NPrinting and allowing users to create reports in different formats that don't allow direct modifications.

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂

Brett_Bleess · ‎2020-09-16

Sonja is correct, there is no means of restricting the use of the data exported to the Excel file by the user. This would have to be accomplished using an extension that included the extra code to do so I believe.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

QlikView export to excel prohibition of data editing

General Question