Pinned topic Can't export Report Book as an Excel 2007 file.
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?
SystemAdmin 110000D4XK41 Posts
SystemAdmin 110000D4XK41 PostsACCEPTED ANSWER
Re: Can't export Report Book as an Excel 2007 file.2013-02-19T14:30:48Z in response to SystemAdminTry 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 2700024PKX20 PostsACCEPTED ANSWER
Re: Can't export Report Book as an Excel 2007 file.2013-05-24T11:08:28Z in response to SystemAdmin
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).