Forum Discussion
Geography Data Type #CONNECT! error message when changing city to country
Only getting an error with Paris to France and nothing else. I am in England so I don't need a VPN. I have the latest Windows and Office update too. Please help. If not solution is there a method where I can use a formal to read Paris and Print France in Column K.
Looks like a bug. For Paris they added French First Republic as a country, but there is no such one among countries now.
- Thank you! Is there a way to fix this? If not, is there a formula that reads my column H (City) and Prints the country in Column K. I.e. when it read Paris in H, Print France in K, without using the geography data type.
