Topic
  • 3 replies
  • Latest Post - ‏2013-05-24T11:08:28Z by richcoll
davper
davper
3 Posts

Pinned topic Can't export Report Book as an Excel 2007 file.

‏2012-10-05T18:09:51Z |
We recently upgraded from 8.5to 10.1.?

When we create a report book, there is no option to save the output as .xlsx (excel 2007 format). We only have .xls.

When the report runs, we get the 'Compatibility Checker' pop-up telling us that we will loose blah, blah, and blah because .xls doesn't support those features.

Does anyone know if there is some setting that we need to change so we can get .xlsx as an option when we create the report book?
Updated on 2013-02-19T14:30:48Z at 2013-02-19T14:30:48Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    41 Posts

    Re: Can't export Report Book as an Excel 2007 file.

    ‏2013-01-18T01:11:13Z  
    I am facing the same issue. Just wondering if you had found any solution?

    Thanks,
    John
  • SystemAdmin
    SystemAdmin
    41 Posts

    Re: Can't export Report Book as an Excel 2007 file.

    ‏2013-02-19T14:30:48Z  
    I am facing the same issue. Just wondering if you had found any solution?

    Thanks,
    John
    Try this:

    On the tab ‘Report Books’ under ‘Output Selection’, change the output type from ‘Preview’ to ‘File’ and then use the browser button to navigate to a network location where you can save your reports in excel format.

    Enter a file name, e.g. STAT REPORTS, select Save and then run.

    The reports will run to Excel to the location you selected and will be named STAT REPORTS1, STAT REPORTS2 etc. You can then change the file name if you need to.

    Hope this helps!
  • richcoll
    richcoll
    20 Posts

    Re: Can't export Report Book as an Excel 2007 file.

    ‏2013-05-24T11:08:28Z  
    Try this:

    On the tab ‘Report Books’ under ‘Output Selection’, change the output type from ‘Preview’ to ‘File’ and then use the browser button to navigate to a network location where you can save your reports in excel format.

    Enter a file name, e.g. STAT REPORTS, select Save and then run.

    The reports will run to Excel to the location you selected and will be named STAT REPORTS1, STAT REPORTS2 etc. You can then change the file name if you need to.

    Hope this helps!

    This is a known limitation in Controller - see here: http://www-01.ibm.com/support/docview.wss?uid=swg2459589

    My favourite workaround is fairly easy to implement - modify the client device so Excel does not complain (see Technote for details).

    - Richard.