Share via

Excel setting options not working properly.

Anonymous
2024-08-20T11:43:52+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?

I checked it on another laptop and this was working fine. I didn't face any problem on that laptop.

I am facing this problem on my pc.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-21T02:16:48+00:00

    Hi Ramanpreet Kaurr,

    Thanks for visiting Microsoft Community.

    In Excel, setting "Automatic Data conversions" is an exclusive feature for Microsoft 365 subscribers. This feature is not included in Office 2021 Home and Student.

    Please refer to the official article: Set automatic data conversions - Microsoft Support

    The reason you can see this setting is that the current Office login has been used by a user with a Microsoft 365 subscription. If you have a Microsoft 365 subscription or an account that includes a subscription, you can switch licenses or accounts in Excel by clicking on File, then Account, and then selecting the option to switch to an account that includes a subscription.

    If you have any further questions, feel free to reply to me.

    Best Regards,

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments