[Solved]: Data Types Stocks and Geography Missing Problem in Excel (3 Solutions)

Last updated: Dec 20, 2023

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.

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.

[Solved]: Data Types Stocks and Geography Missing Problem in Excel: 3 Easy

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.

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.

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.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Stocks and Geography.xlsx

Conclusion

I hope all of the suitable methods mentioned above to fix the data types stocks and geography missing errors 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.

<< Go Back to Stocks In Excel| Excel for Finance | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

2 Comments

Nishant Sep 20, 2023 at 8:29 PM

Not working, I tried so many times to fix the missing “Data Type” in the latest 2023 Office 365 but not fix the issue. Are there any other ways to fix the bugs?
- Reply
  Nujat Tasnim Sep 24, 2023 at 12:09 PM
  
  Hi NISHANT,
  Thank you for your comment. We are sorry that the provided possible solutions aren’t working for you. Before discussing the issue I want to remind you that the Stocks and Geography command under the Data Types tab is only available in Microsoft Office 365. The Data Type tab under the Data ribbon is not available except for Microsoft Office 365.
  
  First, let me mention the three conditions that you must fulfill to show the Data Type tab.
  ● Need to be an Office 365 Subscriber.
  ● Editing Language should be set to English.
  ● Need to sign in to the Office application with your Office 365 account.
  
  Note: You will not be able to use the Data Type tab under the Data ribbon when offline.
  
  Please check whether all three conditions are met. I hope you can solve your problem by fulfilling three conditions and following the three solutions mentioned in the article.
  
  If you haven’t solved the problem yet, here are some other ways that might help you to solve the issue.
  
  ● Check for Updates: Make sure your Office 365 applications are up-to-date. In many cases, Microsoft releases updates and bug fixes on a regular basis, so updating your software may resolve the problem.
  
  ● Check Add-ins: Sometimes third-party add-ins cause problems. Ensure no unnecessary add-ins are enabled and restart Office.
  
  ● Create a New User Profile: Often, issues are related to user profiles. Try creating a new user profile on your computer and see if the issue persists.
  
  You can also provide us with the version information. Also, I would appreciate it if you would upload a screenshot of your Data tab so we can better understand your exact scenario and give suggestions in a productive manner. Please feel free to reach out to us with any other questions.
  
  Regards
  Nujat Tasnim
  Exceldemy.