@mgabri
There's no generic way you could rely on to check if worksheet functions have updated and returned values. For a specific use case you could develop logic based on say a function in the worksheet that returns current date & time, e.g.

=TR("G.M.T=","CF_DATE;CF_TIME")

Compare the values in the cells where the above function returns data to with the current date & time. There's no guarantee however that if the the above function got updated that all the other data retrieval functions got updated as well. To some degree you could manage it by setting Excel calculation mode to manual and force synchronous update. See the following two previous threads for more details.
https://community.developers.refinitiv.com/questions/20247/can-you-please-send-me-the-excel-vba-code-which-ex.html

https://community.developers.refinitiv.com/questions/24672/synchronous-refresh-methods-for-vba-in-excel.html

If you go down this route I suggest you first make sure that Eikon Excel add-in is signed in before refreshing the data. Check out this tutorial.
Or you could check the value in the cells containing data retrieval functions. If the value is a message like "Retrieving..." then the data has not been retrieved by this function.

Alternatively you could do all your data retrieval programmatically using Eikon APIs and output the result into a spreadsheet. This way you have full control over data retrieval status.

Thanks Alex for the response, I was able to resolve partially. Now the problem I am facing is when I run my program using C# .net through solution EIKON add-ins are in active state and everything works but when I just run my complied exe, EIKON excel-addin remains in inactive state and nothing refreshes. Attached are the 2 screenshots for same. I am using Office excel 365 and Visual studio C# 2013.eikon-exceladd-inproblem.pngeikon-exceladd-incorrect.png

I am open for new solution if any. Like API for .net and if you can provide the sample code.

Looking forward for solution.

Regards

Meenakshi

You can programmatically manage which COM add-ins are loaded into a session of Excel. For an example of loading Eikon Excel COM add-in see one of the threads below.

https://community.developers.refinitiv.com/questions/41040/eikon-com-addin.html

https://community.developers.refinitiv.com/questions/29464/launch-excel-com-add-in-with-python-win32com.html

If you prefer retrieving data programmatically, the documentation for Eikon COM and .NET APIs including Quick Start guide, tutorials and code samples is available here on Refinitiv Developer Portal. Just follow the links to Eikon COM or .NET APIs.