Excel does not recognize some regencies from a province

[BasTimmers]

Hello!

I am working in excel and have to make a map like this about every province in Indonesia. Unfortunately Excel does not reconize every regency, but it's written in the right way. (So he does not select those gray boxes) Does anyone have a tip what I can do?

[#2]

If you select the data in question and click on Data types, Geography, Excel should analyze all of them and tell you which it thinks are ambiguous.

[#3]

@Jan Karel Pieterse But what can I do so that Excel will recongnize them?

[#4]

@BasTimmers 

Map Charts is quite sensitive to column names and, of course, place names. I'd add Nort Sumatra as high level; for some regencies add regency into the name (Karo -> Karo regency).

Based on my practice this tool better works with texts, not with structured tables and/or rich data types. In opposite to Microsoft recommendations.

[#5]

Well, that worked. Thanks! Can't you do that for every province in Indonesia ;) haha.

[#6]

@BasTimmers , you are welcome.

Sorry, entire Indonesia takes time. Start yourself and if any concrete questions ask here, someone of us will try to help.

[#7]

Hello! It has worked for every province except Papau province. Could you help me with this? It doesn't recognize quite a few regencies.

[#8]

@BasTimmers 

If you mean Papua, I added couple of recencies for this province and they are shown

What exactly doesn't work?

[#9]

@Sergei Baklan 

Papua indeed. It does not recognize all regencies with a cross next to the table. I have succeeded in all provinces, except this one. If I add the two regencies below the table, the map jumps from Papua to all of Indonesia. Could you help me so that all regencies are recognized? And for Papua Barat the same...

[#10]

@BasTimmers 

Could you please share the file? If you have no option to attach it to the post, when share on OneDrive, Google Disk, whatever, and give us the link. It's time consuming to repeat all steps from the scratch.

[#11]

@Sergei Baklan https://docs.google.com/spreadsheets/d/1uYABuQffgwdtnhk8lopuec6f34kbJzJF/edit?usp=drive_link&ouid=11... 

[#12]

@BasTimmers 

I can't open it

Please make shareable for everyone.

[#13]

I tried a couple of things but nothing works... I can't send it to you :(

[#14]

I could send it your e-mail..

[#15]

@BasTimmers 

Please try to place the file here TechComm

[#16]

Done.

[#17]

@BasTimmers 
I'm not familiar with Papua geography, but wiki says List of districts of Papua - Wikipedia it is divided only on 8 parts, not on 26 as in your file. All of them are recognizable

If to add Central Papua, Highland Papua and South Papua we have 27 regencies all together. Majority are shown

not sure what exactly is missed. Please check the file.