Exporting chart to excel

Options
Louie
Louie Registered Posts: 1 ✭✭✭

Experiencing ongoing issue when I try to export chart (pivot table) to a excel file, the exported file cannot be properly opened and receiving an 'Alert' saying 'file format or file extension is not valid'.

Has anyone experienced similar issue and how to fix it?

Answers

  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 315 Dataiker
    Options

    Hi @Louie
    ,

    If I understand correctly, when you open the file in Excel you receive an error in Excel itself? It would probably be most helpful if you can attach a screenshot of the complete error you are seeing.

    The DSS pivot table chart download will download in xlsx format, which is generally accepted on Excel 2007 and later. There may be some possibility that your version of Excel is older and expects xls format. Can you verify the version of Excel you are using? If you might be using quite an old version, you could try using google sheets to import the pivot table xlsx file instead.

    Thanks,
    Sarina

Setup Info
    Tags
      Help me…