Guide to Write Protection in the Add-On

Write protection keeps data from being written to another source, whether from Cube to your source system or your spreadsheet to Cube. 

The Add-On has two write protection options that can be applied to a specific range or the whole spreadsheet:

Permissions can be edited at any time for a specific range, multiple ranges, the template, or the entire workbook:

Allow Fetching Data

This setting controls data previously published to Cube being fetched into a workbook.  If this is unchecked, data cannot be fetched from Cube.

⚠️ At this time, toggling this setting off also disables the Analyze section containing the Drilldown and Validate tools. If you need to search for unknown errors or drilldown, wait to toggle it off after performing your necessary actions.

Allow Publishing Data

This setting controls data you want to take from your sheet or workbook and publish to Cube.  If this is unchecked, data cannot be published from your sheet into Cube. 

To enable data publishing, click the "Enable publishing on this range" link to be redirected to the permissions panel for the range: