This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Microsoft,
My company uses the excel geography function a lot in our line of work and recently it has been acting up. The geography drop down menu, where you select which type of information you'd like to populate isn't offering the same fields it previously did. We found since this new "update/hiccup" that if we populate City first (we normally populate County first) then we can highlight the newly populated city column and the drop down offers County. Its been working so far but today I have multiple zip codes when I I go to use the Geography function, it only offers Name and Description. When only Name and Description are offered in the geography menu we cant find a way to get geography to work properly and offer City and County.
Just FYI: The zip codes were adding the geography function to only has 5 digits and the formulas are removed beforehand.
Any advise is appreciated!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It seems bing cannot get the city information of the zip.
You may try get help from Bing side.
Please see the link of the sample report, I removed other data that wasn't pertinent to my issue.
Thank you!
Could you share us a test file to reproduce your issue?
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.
The data source of Excel Geography is from Bing. We'd suggest you create a new thread at Bing side.