Share via

Excel setting options not working properly.

Ramanpreet Kaur 0 Reputation points
2024-08-20T07:38:07.3533333+00:00

Excel -> options -> Data -> Automatic data conversion options

I have checked the options then clicked on ok but once you go back to same setting you will find out that the options are themselves unchecked.

I have done the troubleshooting, also I have reinstalled my windows 11 and MS Office 2021 home and student but the problem still exists.

Does anyone have any idea what to do in this case.

Is there any bug in the excel?

Screenshot 2024-08-20 130141

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,623 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,882 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,890 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,144 questions
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,714 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 9,825 Reputation points Microsoft Vendor
    2024-08-21T02:32:35.04+00:00

    Hi @Ramanpreet Kaur

    Since you said you are using MS Office 2021 home and student, this is a one-time payment version, it does not have new feature update.

    In my opinion, Automatic data conversion options won't work in Office 2021. The release of this feature is later than the Office 2021 release date.

    Automatic data conversion is a new feature for Microsoft 365 subscriptions, or one-time payment versions later than Office 2021, such as Office 2024.

    Thanks for your understanding.

    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.