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
10
Views
5
Comments
edited Aug 2, 2018 2:36AM in Essbase 5 comments

Summary

HypRetrieve error -5 (SS_NOT_LOCKED)

Content

Hello,

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

Code:

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.

Register

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