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

Question

Summary

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

John Bruso1 · Answer

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.

Brajesh Shukla-95078 · Answer

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

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

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:

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.

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

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

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.