Why is the Geography Data Type missing in Excel on all my devices and in Excel for the Web?

Marco 0 信譽點數
2026-02-03T03:32:06.6266667+00:00

I have a Microsoft 365 Family subscription and Geography Data Type is missing on all my devices. I can open existing Excel files that already contain Geography data cards, but I cannot create new Geography data types myself. The Data Types gallery only shows “Stocks” and “Currencies”, and in Excel for the Web the Data Types feature does not appear at all. I have already tried reinstalling Office, switching update channels, and using different Windows devices, but the issue remains the same. It seems my Microsoft account is not provisioned for Linked Data Types. How can I get the Geography Data Type enabled for my account?

Microsoft 365 與 Office | Excel | 家用版 | Windows
0 則留言 沒有留言

3 個回答

排序依據: 最實用
  1. 已刪除

    由於違反我們的規範,因此已刪除此答案。 在採取動作之前,會透過自動化偵測手動報告或識別答案。 如需詳細資訊,請參閱我們的管理辦法。


    已關閉註解。 深入了解

  2. 已刪除

    由於違反我們的規範,因此已刪除此答案。 在採取動作之前,會透過自動化偵測手動報告或識別答案。 如需詳細資訊,請參閱我們的管理辦法。


    已關閉註解。 深入了解

  3. Emmanuel Santana 40,170 信譽點數 獨立顧問
    2026-02-03T04:54:26.8266667+00:00

    Hello. This usually indicates an account-level or region-based service limitation, not an issue with the Excel app itself. What country/region is set on your Microsoft account profile?

    • In Excel Desktop, go to File > Options > Language and confirm a supported authoring language (English, Spanish, French, German, Italian, or Portuguese) is set as Preferred. This allows Excel to request Geography data from the backend service.
    • Sign in to Excel for the Web using a different personal Microsoft account. If Geography appears there, it confirms the issue is tied to your account’s provisioning.

    For reference: https://support.microsoft.com/office/linked-data-types-faq-and-tips-d48d6394-c83a-43cd-9d94-78257102f054

    此回答有幫助嗎?


您的回答

答案可由問題作者標示為「已接受」,而由仲裁者標示為「推薦」,這可協助使用者知道答案解決了作者的問題。