User Settings Fields
Learn more about User Settings and Workbook Properties and link to action-related instructions.
Setting Field | Definition | Can be Overridden? |
---|---|---|
General Tab |
||
Round to |
Tells reports to round numbers to the nearest:
|
Yes, by workbook and selection properties |
Show zero in cells with no data |
Tells report how to display cells with no data:
Default: Selected |
Yes, by workbook properties |
Security block result text
|
Tells report what to display in place of the data on save. If you select the Always clear data upon save user setting, the report replaces the data with the text you enter here. The security text displays until the viewer logs in and selects Refresh. Default: "n/a"
|
Yes, by workbook properties
|
Show refresh errors |
Select and you get list of current errors referencing relevant cells when you click Refresh. Default: selected. |
No |
Show refresh warnings |
Select and you'll get a list of warnings with references to the report every time you click Refresh. Default: selected. |
No |
Show refresh informational messages |
Select and you'll get a list of informational messages every time you click Refresh. Default: selected. |
No |
Clear Data |
|
Yes, by workbook properties |
Colors Tab |
||
Elements | Highlights cell data from element intersections. | No |
Labels | Highlights Adaptive Insights labels. | No |