sheet triggers

[#1]

How to make sure that when we open the document or sheet, One particular value from the listbox is selected by default?

Listbox name is 'Names' and value want to be selected on opening is 'John'.........

[daveamz · Accepted solution]

Hi,

Try Settings > Document Properties > On Open > Add Action > Add > Selection > Select in Field

For 'Field' fill in with the fieldname and for 'Search String' fill in the field value you want to be selected on opening.

[#3]

thanks for the reply, the current selection box is showing that 'john' has been selected, but on the basis of this selection, my charts are not getting refreshed. what should i do so that when i open the document, 'john' should be selected and my charts should be refreshed based on my default slection.

[jonathandienst]

Hi

If the charts are not "refreshed", then they are not dependant on the fields being selected in the trigger, or the chart expressions use set analysis that overrides the selection in that field.

Regards

Jonathan