"The cell or sheet that you are trying to change is protected and therefore read-only. To modify a protected sheet or cell, first remove protection using the Unprotect Sheet command."
This error occurs when the cell or workbook being used is protected, and Report Builder cannot create or update requests in protected cells.
This error can be resolved by unprotecting the sheet or workbook. Go to the Review tab and click 'Unprotect Sheet' or deselect 'Protect Workbook'.
If you still get the error message, you can:
- Right-click any data request and select 'Copy Worksheet w/Requests.
- Open a new sheet in an existing workbook or create a workbook.
- Right-click anywhere and select Paste Worksheet w/Requests.