1
I am creating a workbook where the user can paste in their dataset in a worksheet. This dynamic range will be used to generate a series of pivot tables on subsequent worksheets. This works well when the headers are in one language. However, I would like to know if it is possible to change the headers to another language but still automatically get the same pivot tables. This would be so that one workbook can be used for users in different languages. I realise that changing the headers changes the field names and therefore breaks the pivot tables so I imagine that it might only be possible using a VB macro to generate the pivot tables at the press of a button. My VB knowledge is limited - can anyone point me in the right direction? Is it possible without VB? Could something like this be adapted?
Abbie
Posted 2016-03-10T11:04:12.510
Reputation: 295
Do your users need to see the Pivot Table column names in their own language? – Andi Mohr – 2016-03-10T11:26:15.910
Preferably, yes. Are you thinking of a solution that does it in the background? – Abbie – 2016-03-10T14:34:57.903
Yeah, if your users would just be interacting with the pivot table without changing its structure, the idea I had wouldn't require VBA but if you do need your users to see column headers, make changes etc then I'm not sure you can avoid VBA. – Andi Mohr – 2016-03-11T09:43:57.860
Because I don't know the pivot table you want to produce I can't walk you through it. Your best bet is to use the macro recorder to generate VBA as you create a Pivot Table, then try to adapt the code accordingly. Perhaps once you've done that and run into specific problems you could come back and ask a new question.
– Andi Mohr – 2016-03-11T09:51:38.117OK, apparently it's alright for the column headers to stay in English as long as the Pivot Table field names are in the other language. So you suggest translating the field names while recording a macro, then using that? – Abbie – 2016-03-11T11:42:39.010
Give it a try - as I say if you hit a wall, come back and ask a new question (with all the specific details) – Andi Mohr – 2016-03-11T13:08:54.780