Cannot open pivotTable source file�

Aspose.Cells Product Family
21

It may not be an IE issue. I tried OpenInExcel opetion

workbook.Save("SLTReport.xls",FileFormatType.Default,SaveType.OpenInExcel,this.Response);

The Excel can’t open the pivot table. Please see the attachment.

Are there any workarounds for this API?

Thanks

Charlie

22

Hi,

We will look into the issue and get back to you soon.

Thank you.

23

Hi Charlie,

I am using IE6.0 SP2.

If you want to open the file with IE, you should use SaveType.OpenInBrowser not SaveType.OpenInExcel option .

If you use SaveType.OpenInExcel , you must save the file to the disk,then open it with Excel.

24

Hi Charlie,

Please try this fix.

25

The whole threads were talking about SaveType.OpenInBrowser. It has the issue to use Open option. I tried SaveType.OpenInBrowser to see what happed.

What will be the solution for SaveType.OpenInBrowser?

Thanks

Charlie

26

Warren,

I saw so many Aspose demo code in ASP.net using

SaveType.OpenInExcel. Why?

thanks

charlie

27

Hi Charlie,

Thanks for your info.We will check our demo again.

Please try the fix in my previous post and tell us the result.

28

If the url has query string such as "?dept=all", IE won't show the pivot table. The query stirng came from the parent forms when I used Server.Transer(). I can work it aroud for this case.

thanks

charlie