'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Insert Data Not Adding Linked Data Type Fields
Question details
The user is unable to successfully insert fields for linked data types, such as Stocks, Currencies, and Geography, using the Insert Data option in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to extract specific data fields (like Price or Population) from cells that have been converted to linked data types.
- Observed behavior
- The linked data fields fail to insert, or extracting data via formula (e.g., =A1) returns an error stating there is a problem with the formula.
Ensure you have an active and stable internet connection, as Excel's linked data types require online access to fetch live data from Microsoft servers.
Verify Your Microsoft Account and Update Excel
Linked data types are connected experiences that require specific account types and an up-to-date software version to function correctly.
The Stocks and Geography data types are premium features that require an active Microsoft 365 subscription or a free Microsoft account. If you are not signed in correctly or are using an outdated build, the data insertion will fail.
Open Excel and click on 'File' > 'Account'. Verify that you are actively signed in with a Microsoft 365 subscription or an eligible free Microsoft account.
On the same Account page, click on 'Update Options' and select 'Update Now'. Allow Excel to download and install any pending updates, then restart the application.
Configure Supported Editing Languages and Test Formulas
Excel's linked data types are only available when your primary editing language is set to a supported language.
Test in Excel for the Web to Bypass Local Restrictions
Testing your workbook in the browser version of Excel helps isolate whether the issue is with your local software installation or your account.
Try WPS Office for Seamless Data Management
If Microsoft Excel's connected data types are restricted by your organization or subscription issues, consider WPS Office as a free, lightweight, and highly compatible alternative for managing your spreadsheets.
- 1. Download and Install WPS Office: Visit the official WPS website, download the free installation package, and follow the simple on-screen instructions to set up the software.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets, click on 'Open', and select your existing Excel workbooks to continue working seamlessly with full format compatibility.
Frequently Asked Questions
Why do Stocks and Geography data types show an error in Excel?
These data types require an active Microsoft 365 subscription or a free Microsoft account, a stable internet connection, and a supported editing language. If your organization's IT policy has disabled 'Connected Experiences', you will also encounter errors.
How do I manually extract a field from a linked data type cell?
You can manually extract data by clicking a blank cell next to the linked data and typing an equals sign followed by the cell reference and a period (e.g., =A1.). A menu will appear where you can select the specific field you want to extract.
Can I use Excel linked data types offline?
No, linked data types like Stocks and Currencies require an active internet connection to communicate with Microsoft's servers and fetch up-to-date information. They will not refresh or insert new fields while you are offline.
