While working with a large Microsoft Excel dataset, sometimes we need to calculate stocks and geography of our dataset. We will notify the stocks and geography command under the Data Types tab missing in Excel. It occurs for several reasons. is one of them. Today, in this article, we’ll learn quick and suitable ways how to fix the error of the data types stocks and geography missing in Excel effectively with appropriate illustrations.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Introduction to the Data Types in Excel
The workbook might have been produced in Excel using built-in data types, but it might not be compatible with the version of Excel that was used to open it. This is why you may need to start over with a new workbook. You can, for example, view stock cards or any other card type using the Excel Web App. You won’t be able to refresh (you’ll have to sign out and back in) or alter any of your card types if your data types are set to Stocks in the spreadsheet. Make sure you’re signed in to Excel before using the new data type. You will get different types of Data Type in Microsoft Office 365. Such as Stocks, Geography, Currencies, Automatic, Activities, Anatomy, Animals, Chemistry, Foods, Locations, Medical, Movies, Plants, Space, Structures, Terrain, and Yoga. In this article, we will discuss only the Stocks and Geography of the Data types. Stocks and Geography command provides you the information of the given data.
3 Easy Solutions to Solve Data Types Stocks and Geography Missing Problem in Excel
Let’s say, we have a dataset that contains information about several sales representatives of the Armani group. The Name of the sales representatives, their Identification Number, type of products, and the revenue earned by the sales representatives are given in columns B, C, D, and E respectively. From our dataset, we will solve the Data Type Stocks and Geography error. To fix the error, we will Restart our PC, Restart Excel 365, and Reboot Excel App. Here’s an overview of the dataset for today’s task.
1. Restart PC to Workout Stocks and Geography Data Types Missing in Excel
The easiest and time-saving way to fix the data types stocks and geography missing errors in Excel is to restart your PC. Let’s follow the instructions below to learn!
Steps:
- First of all, press right-click on the start menu and a window will appear in front of you. From that window, go to,
Shut down or sign out → Restart
- After restarting your PC, you will be able to fix the error.
Read More: How to Add Data Types to Ribbon in Excel (With Quick Steps)
Similar Readings
- How to Hide Ribbon in Excel (6 Simple Ways)
- Show Ribbon in Excel (5 Quick & Simple Ways)
- How to show the Developer Tab on the Ribbon
- Understanding contextual tabs in Excel Ribbon
2. Reboot Excel 365 to Solve Stocks and Geography Feature Missing in Excel
We can easily solve the missing Data types Stocks and Geography by rebooting the Excel App. Several factors can cause Microsoft Office 365 installation issues. Almost all of these issues can be resolved by resetting the Office app installation. Let’s follow the instructions below to fix the problem!
Step 1:
- First of all, press Windows + I simultaneously on your keyboard. Hence, select Apps.
- As a result, the Apps & Features window will appear in front of you. From that window, type office under the Apps & Features search box.
- Further, press on the Advanced options link.
Step 2:
- After pressing the Advanced options link, a new window named Office will appear in front of you. From the Office window, select the Reset option, and you will be able to fix the problem.
Read More: How to Show, Hide, & Customize Excel Ribbon
3. Repair Excel 365 App to Fix the Problem in Excel
We can repair Excel 365 App to fix the problem. This is the easiest and most time-saving task. Simply follow step 1 which has been done in method 2. After that, from the Office window, select the Repair option, and you will be able to fix the problem.
Things to Remember
👉 Simply restarting Excel 365 will fix the Data types stocks and Geography missing problem. Closing and restarting Windows will also force Excel to reconnect again.
👉 Stocks and Geography command under the Data Types tab is only available in Microsoft Office 365.
👉 Data Type tab under the Data ribbon is not available except for Microsoft Office 365.
Conclusion
I hope all of the suitable methods mentioned above to fix the data types stocks and geography missing error will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.