Data type "Stock" "Currency" not found in MS Office Professional 2024 Excel

Dirk Baader 0 Reputation points
2024-11-28T11:00:08.7133333+00:00

I am using MS Office Professional 2024 and the data type STOCK/Currency could not be found in EXCEL.
Also in the section Option it is not listed to be added in the menu bar.
All examples shown in the web are referring to MS Office 365 - is the are any work around to get this data type available in my MS Office Professional 2024?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,739 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 12,240 Reputation points Microsoft Vendor
    2024-11-29T01:41:50.01+00:00

    Hi @Dirk Baader

    As you find, we are unable to access "Stocks" or "Currencies" data type in Excel for Office Professional 2024, these data types are only available to Microsoft 365 subscribers.

    But if you have a Microsoft account, you can use free Excel for web, then these data types are available. Please note, free OneDrive storage with a Microsoft account is only 5GB.

    enter image description here


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.