We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Protected Sheet Error - Smart View

Received Response
25
Views
7
Comments
edited Aug 2, 2018 2:36AM in Essbase 7 comments

Summary

Protected Sheet Error - Smart View

Content

Hi!

I am using Smart View version 11.1.2.5.210 and we encountered a problem when we tried to refresh a sheet.

The sheet have excel formulas on certain rows and these are protected to avoid those cells from being overwritten.

All others that are not protected can have the data pulled from smart view whenever we refresh them.

Unfortunately, we cannot refresh the sheet anymore as it has this error - "One or more sheet(s) in the workbook are protected. Unprotect the sheets and try the operation again."

Also, when the sheet is not connected to Smart View, it shows the same error whenever we try to input a value on a cell that is not locked.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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