I have a dashboard powered by pivot tables which I want to sent to my teams in Italy, France and Germany.
Can anyone you tell me what the equivalents of “(All)” and “(Multiple Items)” are in a Pivot Table in Italian / French and German language Excel?
The reason for this is that I have “IF” statements which convert “(All)” from the pivot table to “Total” in the dashboard and “(Multiple Items)” to “Selected sites" which then appears in the chart titles.
I know that non-English language Excel will return specific local equivalents of (All) and (Multiple Items) so I plan to use =IF(OR… to cover the alternatives.
Thanks!
Hi Steve,
I would download respective language packs and check myself.
Br,
Anders
Thanks Anders,
I followed your advice so can now answer my own question... so in case of use to any others using Pivot Tables in different languages:
| English | Italian | German | French |
| (All) | (Tutto) | (Alle) | (Tous) |
| (multiple items) | (più elementi) | (Mehrere Elemente) | (Plusieurs éléments) |
Hi Steve,
Glad that you found the answer. When searching for a list of language id:s to use with the TEXT function I found this article (one of many good articles from Mynda), perhaps it could be a useful tool for you in this regard.
Excel Dates Displayed in Different Languages
Br,
Anders
