Hi Team
I tried to save a workbook with pivot table using the following code
MemoryStream stream = new MemoryStream();
obj.ExcelWorkBook.Save(stream, FileFormatType.Default);
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.BinaryWrite(stream.ToArray());
file download dialog box will contain OPEN and SAVE buttons.
If I click the save button, it will save the file. If I click the open button, it displays that “cannot open pivotTable source file…”.
How to fix this issue?
Thanks
Samy T