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


Protected Sheet Error - Smart View



I am using Smart View version 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.


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