Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2013-05-24T11:08:28Z by richcoll
davper
davper
3 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

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

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

    Thanks,
    John
    • SystemAdmin
      SystemAdmin
      41 Posts
      ACCEPTED ANSWER

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

      ‏2013-02-19T14:30:48Z  in response to SystemAdmin
      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!