There's a lot you can do with linked data types. Whether you want to reference linked data types in a formula or simply learn about some of the limitations, check out the content below for more details on how to make the most of linked data types.
Tips and tricks
Open a card:
Press Ctrl+Shift+F5 for Windows or Cmd+Shift+F5 for Mac.
Add a column:
Press Alt+Shift+F10 to open the Insert Data menu. You can also press the Ctrl or Cmd key. Then use your arrow keys to move to a field, and press Enter to choose a field.
Linked data types connect to an online data source. Once you convert text to a linked data type, an external data connection is established in the workbook. That way, if the data changes online, you can update it by refreshing it in Excel. To refresh the data, right-click a cell with the linked data type and click Data Type > Refresh. That will refresh the cell you selected, plus any other cells that have that same data type.
If you want to refresh all linked data types and all data connections that may be in the workbook (including queries, other data connections, and PivotTables), click Data > Refresh All or press Ctrl+Alt+F5.
With data type cards, you can extract more than just your typical values. Some data type cards, such as those for the Movie data type, includes images that you can insert into your workbook. These images are inside the cell.
Convert text to a data type by selecting the cell and going to Data tab > Data Types group > Automatic.
Once converted, an icon will appear in the left of the cell value. Select it to view the card.
In the card, hover over the image and you'll see the Insert Data icon. Select this to insert the image into your workbook.
The image will scale to fit within the cell. To resize it, simply adjust the row or column to increase the size of the cell.
Tip: To view the source attribution of the inserted image, right-click the image and select Show Card.
You can switch out the information for a linked data type in two ways:
Right-click menu: Right-click the cell you want to change > select Data Type > Change.... A pane will appear on the right. Search for the data you want, and then Select to put that information in place of the original one.
From the gallery: Select the cell(s) you want to change, go to the Data tab and in the Data Types group, choose a different data type.
If you don't want the linked data type anymore, just right-click the cell, and click Data Type > Convert to Text. The data type is removed, there's no longer an online connection, and the value in the cell is converted to text. Keep in mind that if you convert the data type to text, any column or formulas that had extracted values from that data type will display the #FIELD! error.
It is also possible to write formulas that use the values from the linked data types. This can be helpful if your data is not in a table. For more information, see How to write formulas that reference data types.
You can always sort and filter data in Excel by using the filter buttons on the column headers. (Turn on filter buttons by clicking Data > Filter.)
But here's a tip for cells with data types: Click the filter button above the cells with icons. Then decide how you want to sort or filter. If you want to do so using the displayed name, keep Display Value selected under Select field. If you want to sort or filter by another field from the linked data type, select that field under Select field.
In this example, we selected the field Area. Excel then used that as a basis for the filter check boxes below, and displays the populations for the countries we have in the table. Also good to know: Excel will change the Number Filter menus depending on the field you select under Select field.
Frequently asked questions
In order to access data types that link to external sources of data such as Bing, Wolfram Alpha, and more, you must meet these requirements:
Have an active Microsoft 365 subscription
Have the English editing language added to Office Language Preferences.
Note: Linked data types from Wolfram Alpha are being gradually rolled out. If you don't see these data types in the Data Types dropdown gallery but would like to use them, you can join the Insiders Fast channel to get the latest updates first. See When do I get the newest features for Microsoft 365? to learn more.
Linked data types pull in reliable data from online sources. Once you've converted a data type, you can view the source of the information by selecting the data type icon to open the card view. If you scroll down, you will see the source. For example, you may see Bing, Wolfram Alpha, etc.
To see what linked data types are currently available, see What linked data types are available in Excel?
We’re continuously working to improve Excel data types. If you can't find a word, the data is incorrect or missing, or you can't achieve your task… we want to know! We’ll use your valuable feedback to make the experience and the feature better.
What feedback are we looking for?
Data quality (wrong, inappropriate, incomplete etc. data)
Data coverage (missing data)
Your experience (using data types and the data)
Suggestions and ideas
For feedback on data quality or coverage
Once you convert to a data type, select the data type icon in the cell to open the card.
Scroll to the bottom of the card and select the flag icon.
Fill out the short survey and submit it. The more specific you are, the easier it is for us to understand the issue and fix it.
For general data type feedback or suggestions
You can send feedback from directly in the Excel app about your overall experience using data types.
Select the smiley face in the top right corner of the ribbon. See How do I give feedback on Microsoft Officefor more details.
Tell us what you like or dislike, or have suggestions about. Submit the form with as much detail as possible.
Yes. Select a cell with a linked data type, then press CTRL+C to copy it. Press CTRL+ALT+V, and then choose Values. This will paste the data type into the new cell, but the data won't be refreshable.
Yes, but they need to use Excel for Microsoft 365 and be on the Insiders Fast channel.
At this time, only Excel for Microsoft 365 supports linked data types. Other versions of Excel may eventually support these data types, as we are continually improving Excel. If you open these new data types in a version of Excel that doesn't support them, #VALUE! will appear for those cells. And #NAME? will appear in place of any formulas that reference these data types.
You cannot select a cell with a data type, and drag the fill handle down to link up text that's not already a data type. The same thing goes for the Format Painter. However, if you are using these data types in a table, you can type under the last row of the table. When you press Enter, Excel will automatically attempt to match your text with online data, and convert it into a data type. It will also do this if you aren't using a table. Just make sure the cell you are typing in has two or more cells above it that already use a data type.
Some traditional Excel features may not function well with linked data types. For example, if you try to create a PivotTable based on information from these data types, you'll get a #VALUE! error. And, using these data types with Power Pivot, Power Query, or even some charts may not work as expected.
At this time, these data types are only available if you have the English editing language added to your Office Language Preferences. We hope to support more languages in the future.