Category:

Show

Duration: 2:15

31 views

0

Here's how to Fix Excel Stock Data Type not showing. Get NordVPN@ https://nordvpn.sjv.io/c/376211/570073/7452.

Here are some steps you can take to fix the Excel Stock Data Type not showing:

1. **Check for updates.** Make sure that your computer is up to date with the latest Windows updates. You can do this by going to Settings - Update & Security - Windows Update and clicking Check for updates.
2. **Restart your computer.** Sometimes a simple restart can fix minor problems with Excel.
3. **Repair Office 365.** A failure of Stock and Geo data types can be persistent. Updating Office and Windows doesn't fix the problem. Try repairing Microsoft Office 365. That often does something to your Office setup which makes Stock and Geography data types reappear. In Windows go to Control Panel | Programs & Features | Office 365 | Change then choose Online Repair. Mac users don't have a similar Repair option. Instead you uninstall Office and reinstall it.
4. **Restart Excel.** Sometimes a simple restart of Excel can fix minor problems.
5. **Sign out of your Microsoft 365 account and then sign back in.** Sometimes signing out of your Microsoft 365 account and then signing back in can fix problems with Excel.
6. **Disable and then enable the Stock Data Type.** To do this, follow these steps:

* Click the Data tab.
* In the Data Tools group, click Data Types.
* In the Manage group, click Data Types.
* In the Data Types dialog box, select Stock and then click Disable.
* Click OK.
* Click the Data tab.
* In the Data Tools group, click Data Types.
* In the Manage group, click Data Types.
* In the Data Types dialog box, select Stock and then click Enable.
* Click OK.

7. **Remove and then add the Stock Data Type.** To do this, follow these steps:

* Click the Data tab.
* In the Data Tools group, click Data Types.
* In the Manage group, click Data Types.
* In the Data Types dialog box, click Stock and then click Remove.
* Click OK.
* Click the Data tab.
* In the Data Tools group, click Data Types.
* In the Manage group, click Data Types.
* Click From Library and then click Online.
* In the Search for online content box, type "stock" and then click Go.
* In the list of available data types, select Stock and then click Add.
* Click OK.

8. **Reset Excel.** To do this, follow these steps:

* Close Excel.
* Open File Explorer and navigate to the following folder:

```
C:\Users\[YourUserName]\AppData\Local\Microsoft\Office\*\Office16
```

* Replace * with the version of Office you are using.
* Delete the XLStart folder.
* Open Excel.

9. **Contact Microsoft support.** If you have tried all of the above steps and you are still having trouble with the Stock Data Type, you can contact Microsoft support for help.

i. There are a few reasons why data types might not be showing in Excel 365.

* **You are using an older version of Excel.** Data types were introduced in Excel 2016, so if you are using an older version of Excel, you will not be able to use them.
* **The data types are not enabled.** By default, data types are not enabled in Excel. To enable them, follow these steps:

1. Click the Data tab.
2. In the Data Tools group, click Data Types.
3. In the Manage group, click Data Types.
4. In the Data Types dialog box, select the check boxes next to the data types that you want to enable.
5. Click OK.

* **The data types are not available for the selected range of cells.** Data types are only available for certain types of data. For example, the Stock data type is only available for cells that contain stock symbols.

If you have tried all of the above steps and you are still having trouble with data types, you can contact Microsoft support for help.

Here are some additional tips that may help you use data types in Excel 365:

* **Use the Data Types gallery to quickly add a data type to a range of cells.** To do this, click the Data tab. In the Data Tools group, click Data Types. In the Manage group, click Data Types. In the Data Types dialog box, click the name of the data type that you want to add. Click OK.
* **Use the Data Type Inspector to see what data type is assigned to a range of cells.** To do this, click the Data tab. In the Data Tools group, click Data Types. In the Manage group, click Data Type Inspector. Click the range of cells that you want to inspect. The Data Type Inspector will display the data type for each cell in the range.
* **Use the Data Type Tools to format and edit data types.** To do this, click the Data tab. In the Data Tools group, click Data Types. In the Manage group, click Data Type Tools. The Data Type Tools group contains a variety of buttons that you can use to format and edit data types.