We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. # Formula not work (2)

Hi! Stephen Can you tell me how to make excel refresh value after saving without using Excel automation. For example: I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. I''''ve open it again and get value of A10. But the value hasn''''t changed. If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. Thanks. vdquang

3 Replies

Hi vdquang, 1) Lets assume that the value in A10 is the sum of A1:A9. A10 = SUM(A1:A9) A10 = 100 [Current Value] 2) Text.xls is opened using ExcelRW and the value of A9 is changed to 20. 3) At this point ExcelRW replaces the value of A9 but the value of A10 is still not changed since it would have to be opened using MS Excel for the calculation to take place and the value to be refreshed. 4) This is where Essential Calculate would do the job, it would calculate the value of A10 without the help of MS Excel and update the value in A10 to be 120. In other words Essential Calculate would allow you to refresh value without the need for opening the spreadsheet in MS Excel. Please let me know if you have any questions. Thanks, Stephen. >Hi! Stephen > >Can you tell me how to make excel refresh value after saving without using Excel automation. > >For example: >I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". >I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. >I''''ve open it again and get value of A10. But the value hasn''''t changed. > >If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. > > >Thanks. >vdquang >

BV Bruce Van Horn November 19, 2004 11:39 PM

OK, so now we know we need the calculation engine, but could you complete the answer by showing us how to update the calculation using the other tool? Thanks! >Hi vdquang, > >1) Lets assume that the value in A10 is the sum of A1:A9. > >A10 = SUM(A1:A9) >A10 = 100 [Current Value] > >2) Text.xls is opened using ExcelRW and the value of A9 is changed to 20. > >3) At this point ExcelRW replaces the value of A9 but the value of A10 is still not changed since it would have to be opened using MS Excel for the calculation to take place and the value to be refreshed. > >4) This is where Essential Calculate would do the job, it would calculate the value of A10 without the help of MS Excel and update the value in A10 to be 120. In other words Essential Calculate would allow you to refresh value without the need for opening the spreadsheet in MS Excel. > >Please let me know if you have any questions. > >Thanks, > >Stephen. > >>Hi! Stephen >> >>Can you tell me how to make excel refresh value after saving without using Excel automation. >> >>For example: >>I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". >>I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. >>I''''ve open it again and get value of A10. But the value hasn''''t changed. >> >>If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. >> >> >>Thanks. >>vdquang >>    