Protect Worksheets

BC Cloud Only - this article only applies to Reporting Intelligence for BC Cloud

Overview

If you protect a worksheet in a workbook using Excel's Protect Sheet feature, the Reporting Intelligence Excel add-in will not be able to generate a report.

Using +LOCK

The Reporting Intelligence add-in will automatically protect locked worksheets (worksheets that have Auto+Hide +Lock in cell A1) after a report is generated and will automatically un-protect locked worksheets when the report is returned to Design mode.

Was this article helpful?

We're sorry to hear that.