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

Visit Redwood Community
HypRetrieve error -5 (SS_NOT_LOCKED) — 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

HypRetrieve error -5 (SS_NOT_LOCKED)

Received Response
edited Aug 2, 2018 2:36AM in Essbase 5 comments


HypRetrieve error -5 (SS_NOT_LOCKED)



Right now I'm migrating Applications from Essbase API to Smart View.


Working one (old)

X= EssVRetrieve(sheetName, Null, 1)

I have tried to change it to smartview so I have used HypRetrieve as there is no need to set Range.

X = HypRetrieve(sheetName)

When I'm trying to execute it, I'm receiving as a result '5'

According to documentation:

SVError = -5 Then

    MsgBox (“Smart View Error: SS_NOT_LOCKED” & vbCrLf & vbCrLf & “Description: The spreadsheet is not locked.”)

On EssVRetrieve, there was possibility to set up the flag (1) and it worked.

How can I lock the sheet?

Howdy, Stranger!

Log In

To view full details, sign in.


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