Excel Stock data type not showing issue : How to Fix

The absence of the Stock Data type in Microsoft Excel can be frustrating for traders who want to view real-time information on the stocks. There are a handful of potential reasons that can be blamed for this debacle. Starting from a simple software glitch to a bad plug-in, we have covered the extensive list of solutions for all the possible reasons.


1. Close and relaunch the Microsoft Excel. Check if that helps you access the Stock data from there.

2. If this is just a software glitch, restarting the machine may help. So, check back the MS Excel sheet for a stock data view.


Fix 1 – Disable the Excel Plugins

One of the key reasons why the Excel Stock Data view is not showing up is due to a faulty plug-in.

Step 1 – To do this, you must launch an MS Excel window.

Step 2 – Go this way –

File > Options


excel options min


Step 3 – In the Excel Options page, go to the “Add-ins” tab.

Step 4 – On the opposite part of the page, toggle the ‘Manage:’ to “Excel Add-ins” from the drop-down list.

Step 5 – Tap “Go” to open the entire list of COM Add-ins on your computer.


excel add ins g min


Step 6 – You will get a list of Excel add-ins present in MS Excel. So, uncheck all those one by one and tap “OK“.


excel add min


Step 7 – Coming back to the main Excel Options window, make sure you are at the ‘Add-ins’ tab.

Step 8 – After this, make sure to toggle the ‘Manage:‘ box to “COM Add-ins” from the list and tap “OK“.


com add ins go min


Step 9 – Disable all the COM Add-ins as well in there (just uncheck all the boxes there and tap “OK“).


uncheck com min


After you have disabled all the add-ins in MS Excel, you shall have no problem getting the Stock Data view back in there.

If the error persists, follow the next solution.


Fix 2 – Check for Excel updates

Look for an update for Microsoft Excel and update it to the latest version.

Step 1 – Open the Microsoft Excel.

Step 2 – Next, get to the “Accounts” section.


account min


Step 3 – On the right-hand pane, click the “Update Options” option and click the “Update now” option from the list menu.


update now min


After this, you won’t have much trouble seeing the Stock Data view in Microsoft Excel.


Fix 3 – Run the Excel in Safe Mode

Consider running the Excel in Safe Mode and try to view the Stock Data type in there.

Step 1 – Just right-tap the mouse on the Start button.

Step 2 – Next, click to open the “Run” dialog box.


run min


Step 3 – Copy and paste this term there and hit Enter.

excel /safe


excel safe


Try getting a view of the Stock Data type in MS Excel. Proceed to the next one, if you still can’t see the Stock Data type in there.


Fix 4 – Run an online repair

The absence of a particular Office file can be the reason why you can’t view the Stock Data type in Excel.

Step 1 – Search for “installed apps” from the taskbar.

Step 2 – Click “Installed apps” to open that specific part of Settings.


installed apps min


Step 3 – Perform a search for the “office” app from the search box in Settings.

Step 4 – Once you have found the Office package, go to the menu and click “Modify“.


office modify min e1706845190528


Step 5 – As the Office setup window elevates, choose the “Online repair” option.

Step 6 – Next, tap “Repair” to initiate a package repairing process.


online repair min


The office will automatically analyze the local files and replace any corrupt/missing files in there. So, after this, check for the stock data view in Excel.

Hope these fixes have helped you resolve the issue.