Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Back to discussions
Expand all | Collapse all

PAW-function Export to Excel: sheet count is off by 1

  • 1.  PAW-function Export to Excel: sheet count is off by 1

    Posted 06/09/20 05:47 AM
    In PAW there's the option of exporting a PAfE-workbook to Excel, either as a slice or a snapshot. 
    When the workbook contains just the 1 sheet, the export menu indicates that the export file will contain 2 sheets.
    But then the resulting export only contains the one sheet that we began with. There's also no hidden sheet, I've checked that.

    When you try to export an excel book with multiple sheets, the export menu indicates that there's an extra sheet (so number of sheets +1). But then the export again only contains those sheets that are actually in the workbook.


    So what's up with that second/extra indicated sheet?? Why does the export menu think there's an extra one? Does anyone know?



    ps. I've seen this behaviour in multiple PAW versions (2.0.43 and 2.0.53)

    ------------------------------
    Amarins van de Voorde
    ------------------------------

    #PlanningAnalyticswithWatson


Related Content