Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Protected Worksheets

Overview

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

Using +LOCK

The Jet 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.

Published:

Protected Worksheets

Overview

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

Using +LOCK

The Jet 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.

For an optimal Community experience, Please view on Desktop