Hi krasman - you're in the wrong newsgroup ;-)

This one is for XML (the tag-based, HTML like thing) and you meant to
post in I imagine microsoft.public.xls (rather than the similar group
microsoft.public.xsl which is a processing language for XML files)

HTH
Cheers - Neil

On Tue, 28 Apr 2009 20:04:32 +0100, "krasman" <krasman@h...>
wrote:

>hi,
>
>i have an excel file with two sheets: sheet1 and sheet2. let's say that 
>sheet1 cell A1 has a value. in sheet2, cell A1 there's a formula, something 
>like Sheet1!A1 + 10. so, if i put 10 in sheet1, sheet2 should have 20. in 
>excel 2007 this is a basic formula, and it works perfectly. however, i want 
>to do the same thing using open xml sdk 2.0. i can insert values in sheet1, 
>cell A1, but the sdk doesn't recalculate the value of sheet2, A1. using 
>mycell.CellValue.Remove(), the formula is updated when i open excel. but i 
>need do do this directly using sdk and not excel. something like:
>
>my function()
>   insert value in sheet1, A1
>   do some processing
>   get value from sheet2, A1 -> this gives the wrong value
>   more processing
>end function
>
>can you help me?
>
>thanks
>
>kras 
>
------------------------------------------------
Digital Media MVP : 2004-2009
http://mvp.support.microsoft.com/mvpfaqs