May 24 2019 02:53 PM
How to customize name of months in Pivot Table when grouping dates without changing „Format” in Region (Control Panel) in Windows - OR- How to prevent Excel from blocking sorting, autofilling and custom lists when I do change that „Format”
I use Excel within Office 365 Personal on Windows 8.1 Pro on Lenovo ThinkPad X1 Carbon (from 2013 or 2014...).
Main, initial problem:
When I group dates by month in pivot table, as names of months I get abbreviations of Polish names of months, while I need English abbreviations.
Problems that I encountered trying different solutions:
[I list them so maybe somebody can use them as un/satisfactory solutions, and also you know what I’ve already done]
Additional information:
So - what to do…? How to have English abbreviations of months when grouping dates in pivot tables? Of course it has to be automatic, easy to use on every new pivot table. Alternatively, how to maintain sorting and autofilling and editing custom lists when changing regional settings in Windows? And is there anything I can do to solve these problems, anything related with my system, settings...?
At least tell me that it’s impossible, so I stop trying ;)
Best regards to all :)
May 27 2019 12:32 PM
Update:
Today the problem was fixed by Microsoft Support technician who deleted old settings using “Registry editor”. From what I understood, there were some remainings from previous Excel/ Office versions which made confusion regarding language and related settings. It seems not everything is removed at deinstallation and sometimes it has to be removed manually. I don’t know exactly what was removed/changed, but it’s good to know where to search for a solution when standard solutions that I tried at the beginning don’t help. I only hope nothing else was damaged on the way, but for now all seems in order.