Categories
Password protect Excel output?
Summary
Can you password protect excel outputs from BI Publisher
Content
Hi,
Not sure that this is the right place for this post, sorry if not.
I've been looking to try and password protect excel outputs from a BI Publisher report so this can be sent directly to a customer rather than having to manually do this each time they require an updated report.
I've seen that you can do this for PDF outputs and that excel was not currently available but these were older posts and wondered igf this had been rolled out to excel formats as I couldn't find any update.
Thanks
Version
11.1.1.9.0
Comments
-
Hi Lee,
Password protected excel is still not possible in the latest release.. Not sure if it is being worked upon by the development team.
Thanks,
Sricharan
0 -
Moved to OBIEE. Add/search for this in the IdeaLab.
0 -
Hi Lee,
You can use password protect as of Release 19C for PPTX, DOCX, XLSX, PDF (the password protection will apply to both online viewed reports and scheduled jobs):
TO APPLY PASSWORD PROTECTION
- To apply password protection at server level (i.e. for all reports that generates the output in PPTX, DOCX, XLSX, PDF)
- Navigate to Administration page
- Open Properties under Runtime Configuration section
- Enter a desired password for the file formats
- To apply password protection at report level (i.e. for only specific report for PPTX, DOCX, XLSX, PDF outputs)
- Edit a report
- Navigate to Report Properties, Formatting tab
- Enter a desired password for the file formats
NOTE: Excel output in .XLS format generated from Excel templates do not support password protection.
Kind regards,
Robert
0 -
Yes. password protect Excel feature has been made available since 19C. However we can set a static password only as of now. Dynamic password isn't feasible at this point of time.
Please refer the below article for detailed steps on how to achieve it.
https://fusionhcmknowledgebase.com/2019/02/now-you-can-password-protect-excel/
Thanks,
Sricharan0