Error when uploading Excel template containing PivotTables Modified on: Tue, 21 Feb, 2017 at 7:02 AM

dRofus shuts down when you try to upload an Excel template that contains pivot tables.


Solution:

  1. Check that the columns in the excel file are in the same order as the fields in dRofus (tip:create a "data" sheet where all the data is filled our from dRofus and a "report" sheet where you put the pivot table in.
  2. Check the PivotTable Settings
    1. Open the Excel file
    2. Select PivotTable
    3. Right-click and choose PivotTable Option

    4. Go to Data and UNCHECK the option "Refresh data when opening the file"

    5. Choose OK
    6. Resave file
    7. Try to upload to dRofus as template.