HypRetrieve error -5 (SS_NOT_LOCKED)
SummaryHypRetrieve 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?