Essbase

Get Involved. Join the Conversation.

Topic

    Chris Badenhorst
    Capture Data in Unlocked Cell in Protected Workbook Smart...
    Topic posted March 20, 2019 by Chris BadenhorstBronze Medal: 1,250+ Points, tagged Essbase, Smart View 
    127 Views, 6 Comments
    Title:
    Capture Data in Unlocked Cell in Protected Workbook Smart View Error
    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.

    Alternatively, I can use Smart View Functions instead of an ad-hoc grid, but this slows down the submission and retrieval of data and you cannot submit text labels (Typed Measures) with Smart View Functions.

    Anyone know how I can protect the Ad-Hoc Excel sheet but still allow users to enter data?

    Many thanks.

    Chris.

    Version:
    12.2.1.1.115
    Image:

    Comment