Fix Live Currency Data Types Not Refreshing in Excel
Question details
Users are experiencing issues where live currency data types fail to refresh or are missing entirely from the Excel ribbon for certain Microsoft 365 accounts.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to update or insert linked currency data types in an Excel workbook.
- Observed behavior
- Currency data types do not refresh properly, and the Data Types command option may disappear from the ribbon for affected accounts while working fine for others.
Verify that you are connected to a stable internet connection and logged into the correct Microsoft 365 account, as linked data types require internet access and a supported premium license.
Verify Microsoft 365 Subscription and Test on Excel for the Web
Ensuring your account has the correct permissions and testing on the web version helps isolate whether the issue is with the desktop app or the account itself.
Linked data types are a premium feature that requires a specific Microsoft 365 subscription tier. If your subscription recently expired or changed, the feature may become disabled.
Sign into your Microsoft 365 account online and confirm you have an active subscription that supports linked data types.
Upload your problematic Excel workbook to your OneDrive or SharePoint account.
Open the workbook using Excel for the web in your browser.
Right-click the currency data cells and look for the 'Data Type' or 'Refresh' option to see if the feature functions correctly online.

Test with a New Workbook and User Profile
If the web version works but the desktop app does not, the issue might be isolated to a corrupt workbook, device cache, or Windows user profile.
Request Administrator Support for Service Issues
If the issue persists across multiple devices and accounts, it is likely a backend service issue that requires Microsoft Support intervention.
Try WPS Office for Your Spreadsheet Needs
If Microsoft Excel's linked data types are causing subscription headaches or backend service errors, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet solution that is free to use and easy to navigate.
- 1. Visit the Website: Go to the official WPS Office website.
- 2. Download the Installer: Click the download button to get the free installation package for your operating system.
- 3. Install and Use: Run the installer, follow the prompts, and open WPS Spreadsheets to start managing your data.

Frequently Asked Questions
Why is the Data Types option completely missing from my Excel ribbon?
The Data Types option may be missing if you are not logged into a Microsoft 365 account with an active, premium subscription, or if your organization's IT policy has disabled connected experiences.
Can I manually refresh currency data in Excel?
Yes, you can manually refresh currency data by selecting the cells containing the linked data, right-clicking, and choosing 'Refresh', or by navigating to the Data tab and clicking 'Refresh All'.
Does Excel for the web support currency data types?
Yes, Excel for the web supports linked currency data types. If they fail to work on your desktop application, uploading the workbook to OneDrive or SharePoint and opening it online is a recommended troubleshooting step.
What should I do if currency data fails to refresh on all my devices?
If the issue happens across multiple devices and networks, it is likely a backend account issue or Microsoft service outage. You should contact your IT administrator to open an official support ticket in the Microsoft 365 Admin Center.




