Office Settings & Configuration

Fix Excel Stock Data Type Add Field Icon Missing in Excel 2016

Steve KSteve K Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Start Excel in safe mode

Press Windows + R, type excel /safe in the Run box, and press Enter to open Excel in safe mode.

2
Open the affected workbook and select a stock cell

Open the workbook, select a cell that uses the Stock data type, and check whether the Add Field icon appears.

3
Disable add-ins if the 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.

4
Re-enable add-ins one at a time

Restart Excel normally after enabling each add-in, check the Add Field icon again, and leave the conflicting add-in disabled.

Expected result: If the Add Field icon appears in safe mode, a disabled add-in is the likely cause and normal Excel should work after isolating it.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
  2. 2. Install and launch WPS Office: Open the downloaded installer, follow the on-screen instructions, and launch WPS Office.
  3. 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.
Opens and edits XLSX workbooks created in Microsoft Excel with high format compatibility.Runs without the same COM add-in conflicts that can hide Excel data type icons.Free and lightweight Office suite with familiar spreadsheet tools.Seamless migration from Microsoft Excel with a similar ribbon interface.
microsoft office alternative - wps office

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.