Protected Sheet Error - Smart View
SummaryProtected Sheet Error - Smart View
I am using Smart View version 188.8.131.52.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.