Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Word BI Publisher How to protect .rtf template that generates .xls output?

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