Word BI Publisher How to protect .rtf template that generates .xls output? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Word BI Publisher How to protect .rtf template that generates .xls output?

Received Response
57
Views
2
Comments

Summary

Word BI Publisher How to protect .rtf template that generates .xls output?

Content

I'm using Peoplesoft to deliver my BI Publisher Reports. Is there a way in BIP to lock down the .xls spreadsheet so users can't change values?

Thanks,

John

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    You can use excel property to protect the excel sheet from update

    1. Click the image button on the top left corner of current worksheet to select the whole cells.

    image

    2. Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box. In the dialog box, uncheck the Locked box under the Protection tab, and then click the OK button. See screenshot:

    image

    3. Now select the cells you want to make them as read only (here I select cells of range A1:C18). Press the Ctrl + 1 keys simultaneously to open the Format Cellsdialog box, check the Locked box under the Protection tab and click the OK button.

    image

    4. Go ahead to click Review > Protect Sheet. See screenshot:

    image

    5. Specify and confirm your password to protect the worksheet as below screenshot shown.

    image

    Now cells in the locked range are read-only now. When you try to edit these specific cells inside the range, you will get a prompt box as below screenshot shown.

    image

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Wow, thanks Brajesh. I was actually looking for a way to protect the rtf data if a user outputted it from peoplesoft into excel. Sorry for the confusion. I probably need to look into a peoplesoft feature and not a BIP feature.

    If I was starting from an excel template your solution would work.