Forum Discussion

jmills3034's avatar
jmills3034
Copper Contributor
Jan 29, 2025

Excel geography data incorrect

Hi there! Was directed to this group after a Microsoft support chat that wasn't able to resolve my issue. I have a worksheet that I track some address data in using formulas and the Geography Data ...
BI & Data Analysis
excel
Formulas and Functions
jmills3034's avatar
jmills3034
Copper Contributor
Jan 29, 2025

Thanks!

I have submitted a feedback comment on this

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 01, 2025

    Feedback is always useful, but I'm pessimistic if something changes. In this forum lot of such samples and nothing happens. I'd do not expect the problem will be fixed in some future.

    Another sample

    Does someone know why Belgrade is in Ottoman Empire which disappeared more than hundred years ago?

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Feb 01, 2025

      This is what I see:

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Feb 01, 2025

        Riny_van_Eekelen , interesting, thank you for sharing. With VPN I also have Serbia. Without it - Ottoman Empire. It looks like Microsoft provides different results to countries which are under the sanctions and/or in conflict, and which are not. Another headache for them.

        Anyway, even without politics results are not always adequate. Especially for regions where were any changes in administrative divisions during previous 10 years or so, or for ones which are too far from USA.

        Back to initial question I have no idea what shall be correct data to play with variants in names.

Resources