Not able to open excel after exporting to excel, multiple times .

Question

User1648372490 posted

I am trying to export to excel using SSRS reports , its working fine with pdf ,but while exporting to excel ,if i want to export multiple times the excel is not opening after 2-3 times. I am using MS Excel 2010. Help me....

 

 

 

 

Answer 1

User1471008070 posted

Hi,

You mentioned it does not work?Could you please clarify your scenario? does it have some error message? detail information is a big help for us to troubleshooting.

Thanks,
Challen Fu

Answer 2

User1629046272 posted

Hi,

It seems due to "Response.End", to overcome you can include the following javascript in aspx page.

function EnableExport()
{

window.WebForm_OnSubmit = function()
                      {return true;};
}
Then, call on client click of the asp button as follows <asp:Button ID="btnExport" Text="Export" runat="server" OnClientClick = "EnableExport()" OnClick="btnExport_Click" />

Hope it helps. :)