Thank you for using Syncfusion products.
In order to achieve your requirement you should make use of calculated value instead of refresh range property. Calculated value property returns the updated value. We have shared the code snippets for your reference.
workbook.CalculationOptions.CalculationMode = ExcelCalculationMode.Automatic
workbook.CalculationOptions.IsIterationEnabled = True
For Each worksheet As IWorksheet In workbook.Worksheets
For Each item In Data
worksheet.Range(item.ExcelRow, item.ExcelColumn).Value = item.ExcelValue
Dim cell As String = CommonFunctions.GetExcelColumnName(item.ExcelColumn).ToString() + item.ExcelRow.ToString()
Dim calculatedvalue As String = worksheet.Range(cell).CalculatedValue()
Please let us know if you need any clarification.
We are able to reproduce this issue and we have logged an issue report on this. As per our forum regulation, we will not be able to share the fix for the issue through forum. However, if you are interested in receiving this fix then, we would request you to use our Direct-Trac Support system to get the fix for this issue and resolve all your technical queries. For more details, please login into http://www.syncfusion.com/Account/ and we will be happy to help you. Please let us know in case of any queries.
We would request you to use our Direct-Trac Support system to resolve all your technical queries and also please provide as the sample file for this scenario. For more details, please login into http://www.syncfusion.com/Account/ and we will be happy to help you. Please let us know in case of any queries.