When creating or editing a request in Report Builder, a user can get the following message:

Clipboarder.2015.01.23-002

"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.

Resolving the error

This error can be resolved by unprotecting the sheet or workbook. Go to the Review tab and click 'Unprotect Sheet' or deselect 'Protect Workbook'.

Clipboarder.2015.01.23-003

If you still get the error message, you can:

  1. Right-click any data request and select 'Copy Worksheet w/Requests.
  2. Open a new sheet in an existing workbook or create a workbook.
  3. Right-click anywhere and select Paste Worksheet w/Requests.

Този материал е лицензиран под лиценз Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported  Публикациите в Twitter™ и Facebook не попадат под клаузите на Creative Commons.

Правни бележки   |   Правила за онлайн поверителност