Thanks for the reply but somehow this didn't work out for me .
Following is the sample code that I have used , I am attaching the template I have used for the following code :
Workbook book = new Workbook();
Workbook book2 = new Workbook();
book.Worksheets.Cells[1, 2].PutValue(5000);//This will trigger change is cell value in both the sheets after formulae calculation.
book.Save("yahoo.xls", SaveType.OpenInExcel, FileFormatType.Excel2003, HttpContext.Current.Response);
I feel the issue is :
Demo.xls is linked to Demo2.xls but during runtime it creates a temp/virtual copy of Demo2 which is located C:\Documents and Settings\sinpank\Local Settings\Temporary Internet Files\Content.IE5\WN4NU1GJ\
but as I am operating on copy available at C:\ it fails to update the virtual copy somehow.
Or maybe syntax I used is wrong ?