Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Capture Data in Unlocked Cell in Protected Workbook Smart View Error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Capture Data in Unlocked Cell in Protected Workbook Smart View Error

Received Response
10
Views
6
Comments
edited Mar 20, 2019 8:17AM in Essbase 6 comments

Summary

Capture Data in Unlocked Cell in Protected Workbook Smart View Error

Content

Hi

I've created an ad-hoc grid to enable users to load data into an OAC Essbase cube. I want to protect the Excel sheet so that users don't break the structure or change member names etc. but should be allowed to enter data where required.

I have unticked 'Locked' under Protection in Format cells for the cells where they should enter data. However, after I've protected the sheet, I'm getting a Smart View error that you cannot enter data into the unlocked cells and that the sheet should be unprotected. This is not an Excel error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!