A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Hi Ashish,
The name displayed when you open the file and apply an comment is based on the display name of the account you are logged into Office. So if the display name is still your random name, then the name on comment will not be changed as well both SharePoint and Office client.
However, there is a workaround that you can change the new comment display name via File>Options>General>under Personalize your copy of Microsoft Office>change the User name.
*And this change is only available on new comment, the previous comment display name can't be changed. This feature is not available since Excel 2010 and here are some articles to prove it:
How to change all comments’ author name in Excel?
Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.
If my understanding of your problem is wrong, please correct me and provide some information for me:
- You mentioned "When I created new microsoft account, it was created with my business email", do you mean that there are two accounts under your business email? And they are Business account(Work or School account) and Microsoft account?
- You mentioned "I have changes my profile name by login in to MS account", where did you change your name?
- Where do you want to change the comment name? SharePoint Online or Office client(you can open the SharePoint file via Office client application)?
Regards,
Jazlyn