Fix Excel Stock Data Type Add Field Icon Missing in Excel 2016
Question details
The user needs to restore the missing Add Field icon for the Excel Stock data type after converting company names, so linked stock fields can be inserted and updated.
- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- The user converted company names to the Stock data type in an Excel 2016 workbook and selected a cell, expecting the Add Field icon to appear for inserting linked stock fields.
- Observed behavior
- The Add Field icon does not appear in the selected cell, preventing linked stock field insertion.
Save and close the workbook, and make sure you have permission to start Excel in safe mode or run an Office repair on this computer. Keep your Microsoft account or Office product key available if reinstallation becomes necessary.
Start Excel in safe mode and isolate add-ins
Use this first to identify whether an Office or COM add-in is blocking the Stock data type Add Field icon.
Excel safe mode loads without most add-ins, so it quickly shows whether the missing icon is caused by an add-in conflict.
Press Windows + R, type excel /safe in the Run box, and press Enter to open Excel in safe mode.
Open the workbook, select a cell that uses the Stock data type, and check whether the Add Field icon appears.
Go to File > Options > Add-ins, choose COM Add-ins from the Manage drop-down, click Go, and clear the checkboxes for the listed add-ins. Repeat for Excel Add-ins if needed.
Restart Excel normally after enabling each add-in, check the Add Field icon again, and leave the conflicting add-in disabled.
Repair Microsoft Office online
Use this if safe mode or add-in isolation does not restore the Add Field icon.
Reinstall Microsoft Office as a final step
Use this when safe mode and Office repair fail; reinstallation has resolved the missing Add Field icon for some users.
Switch to WPS Office When Excel Add-in Issues Block Stock Data Fields
If Excel 2016 add-ins or installation issues keep breaking linked data types, WPS Office is a free, lightweight Office alternative with a familiar ribbon interface and strong XLSX format compatibility. You can open and edit existing Excel workbooks and migrate from Microsoft Office without re-creating files, reducing the add-in conflict risks that can hide Excel Stock data type features.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
- 2. Install and launch WPS Office: Open the downloaded installer, follow the on-screen instructions, and launch WPS Office.
- 3. Open your Excel workbook: In WPS Spreadsheets, click Menu > Open or drag the .xlsx file into WPS Office to view and edit the workbook.

Frequently Asked Questions
Why is the Add Field icon missing after I convert text to the Stock data type in Excel 2016?
It is usually caused by an Excel add-in conflict, a damaged Office installation, or a partial Stock data type link. Start Excel in safe mode, disable add-ins, and then repair Office if the icon still does not appear.
How do I start Excel 2016 in safe mode?
Press Windows + R, type excel /safe, and press Enter. Then open your workbook and select a Stock data type cell to check the Add Field icon.
Does Excel safe mode disable all add-ins?
Yes, Excel safe mode loads without most add-ins and customizations, so it helps identify whether an add-in is blocking the Stock data type Add Field icon.
Can WPS Office open Excel files that use the Stock data type?
WPS Spreadsheets can open XLSX workbooks and preserve general worksheet data, but the Excel linked data type feed may not behave the same as in Microsoft Excel.




