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

Get FREE Advanced Excel Exercises with Solutions!

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.

excel data types stocks and geography missing


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


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.

Reboot Excel 365 to Solve Stocks and Geography Feature Missing in Excel

  • 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.

Reboot Excel 365 to Solve Stocks and Geography Feature Missing in Excel

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.

Repair Excel 365 App to Fix the Problem in Excel]


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.


Related Articles

Tags:

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo