Error when Saving Back to a Protected Sheet

Summary:

The following error may occur when selecting Update Excel in the Planning Window of a published budgeting template. 

Symptoms:

Cause:

This error occurs when a Budget form is protected and the first row and column are locked.

Resolution:

There is code for BI360 Planning in the first row and column, so these cannot be locked. To resolve this issue follow the steps below:

1. In the report template, unprotect the sheet
2. Unhide the rows
3. Highlight the first row and right click
4. Choose the "Format Cells" option
5. Go to the Protection tab
6. Un-select the box for the Locked option

After you un-check this box, you can select OK, protect the workbook and publish the form again. 

Properties:

Applies To:

Planning 4.x