Hi @Mahima Kankriya ,
I have carefully read your requirements. You want to automatically put the contents of the status column of this file in the document library anywhere in the excel file every time you open the excel file located in the sharepoint library.
Per my knowledge, you can achieve this function through Power Automate.
In fact we are currently providing help on SharePoint in the Q&A forum, and Power Automate is a product independent of SharePoint which we are not so familiar with. Regarding the difference between these two methods which is more related to Flow, we would recommend that you go to the forum dedicated to flow for more professional help, there will be very professional people to solve the problem for you quickly:
Microsoft Power Automate Community
Thanks for your support and 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.