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?
Please save your file to disk or use only SaveType.OpenInExcel option if it works fine for your requirements. We will look into your issue further why you are not able to use SaveType.OpenInBrowser option fine there.
By the way, could you give us your environment details, OS, .NET framework, IIS Settings, and Browser type etc.