Settings in Excel – dictionary

New dictionary

The view of the dictionary settings in Excel

Language

Here you can determine the languages which, when a new dictionary is created, will be allocated to the respective columns in the dictionary. To do this, simply enter the desired language in the corresponding field.

Visible language

If you use fewer than five languages in your Excel file, hiding the unused columns will make the file appear more organized. Simply select the number of visible languages.

	Good to know
	To change the names of the languages later on, or to reduce the number of languages shown, on the “*Translation” ribbon in the “Dictionary” group, under “Translation Manager”, click on the drop-down menu and select “Configuration”.

Update

Update sub-dictionary when saving

The sub-dictionary will be automatically updated when it is saved.

Also update hits when updating the dictionary

If the name of a worksheet is changed in the course of the project, the names of the hyperlinks that refer to hit(s) will have to be adjusted accordingly. This is done automatically during updates if the “Review and update hits” setting is activated.

For very large workbooks, the dictionary updates can be accelerated by deactivating the “Review and update hits” function. In this case, you can manually update the adjustment of the hyperlinks by clicking “Update” in the “Hits” group.

Edit terms

Check for requested terms before opening the translation manager

This function ensures that no requested terms are missed. Each time you enter the translation manager, it is checked for requested terms. If there are requested terms, the “Requested terms” dialog opens automatically.

Sorting

Move crossed-out terms to the bottom

If a dictionary term is not used in any sheet and thus does not have any more hits in the dictionary, it is displayed as crossed-out in the main language.

If this has been ticked, the unused terms will be moved to the end of the dictionary when sorting a language.

See also

The translation manager
Settings in Excel
Settings in Excel – transmitter values
Settings in Excel – read version

Further contents

→ firesys website
→ Customer area
→ YouTube