Excel workbook with pivot table corrupted after saving

Posted by: yyoshimura on 7 February 2021, 6:28 pm EST

  • Posted 7 February 2021, 6:28 pm EST

    Hi,

    We are facing a new problem when saving some file with pivot table connected to analysis service data source. Please refer attachment for reproduction.

    [AdHocReport_test.xlsx] can be opened by excel with no problem with a dialog prompted to connect to the data source.

    [AdHocReport_test_saved.xlsx] is the file saved using the API. It is corrupted when opened in Excel.

    We expected the behavior should be the same after saving without file corruption.

    Please help to investigate this issue. Thanks.

    gcexcelperformance.zip
  • Replied 7 February 2021, 6:30 pm EST

    By the way, we are using the latest version of Documents for Excel .NET with version v4.0.3.
  • Replied 9 February 2021, 10:31 pm EST

    Hello,

    We have escalated this to the developers and will let you know as soon as we get any update on this from the developers' end.
    [Internal tracking id: 3747]

    Regards,
    Prabhat Sharma.
  • Marked as Answer

    Replied 8 March 2021, 1:42 pm EST

    Hello,

    This issue has been fixed in the latest version of GcExcel i.e. 4.0.4.
    Please update it in your project to avoid the issue that you were facing.
    https://www.nuget.org/packages/GrapeCity.Documents.Excel/
    Regards,
    Prabhat Sharma.
  • Replied 8 March 2021, 4:10 pm EST

    We confirmed that the issue is solved using the latest version.
    Thank you for your great support.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels