Stocks and Geography Data Types are Missing in Excel – 3 Solutions

Data Types in Excel

There are different Data Types in Microsoft Office 365: Stocks, Geography, Currencies, Automatic, Activities, Anatomy, Animals, Chemistry, Foods, Locations, Medical, Movies, Plants, Space, Structures, Terrain, and Yoga.


This is an overview of the sample dataset.

excel data types stocks and geography missing


Solution 1 – Restart the PC to Workout Stocks and Geography Data Types Missing in Excel

Steps:

  • Right-click the start menu and in the displayed window, go to

Shut down or sign out → Restart

  • After restarting your PC, you will be able to fix the error.

Solution 2 – Reboot Excel 365 to Solve Stocks and Geography Feature Missing in Excel

Step 1:

  • Press Windows + I.
  • Select Apps.

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

  • In the Apps & Features window, enter Office in Apps & Features.

  • Click Advanced options.

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

Step 2:

  • In the Office window, select Reset.

You will be able to fix the problem.

 


Solution 3 – Repair Excel 365 App to Fix the Problem in Excel

  • Follow step 1 in Solution 2.
  • In the Office window, select Repair.

You will be able to fix the problem.

Repair Excel 365 App to Fix the Problem in Excel]


Things to Remember

  • Stocks and Geography Data Types are only available in Microsoft Office 365.

 


Download Practice Workbook

Download the practice workbook to exercise.

 


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

2 Comments
  1. 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?

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo