Schedule export to excel

Is it possible to schedule export to Excel – and how?

Ideally I want my export to include every object in my TARGIT Document.



  • You can either use:


    Or directly within the crosstab by right clicking and: 

  • When using the Scheduled Jobs, is it possible to schedule all crosstabs in the file? I would like to get the same result as clicking the Excel->Open, where you get all crosstabs in separate Excel tabs. 

    It seems to me that you can only choose one crosstab when adding it to a schedule. 


  • Export all crosstabs to Excel

    In addition to Steppi's comment. You can specify to export all data objects in the Format pane of Schedule Job setup. Just select MS Excel format and check "Export all data objects to multiple sheets"

  • I have found that a lot of people like to make pivot tables right away after receiving the Excel file, but TARGIT will naturally use it's heirarchy and leave some cells blank. If you check off the "Repeat dimension members for all rows/columns" then it will fill in those blank cells instead of use the natural heirarchy!


Please sign in to leave a comment.

Didn't find what you were looking for?

New post