Skip to Content
0
Former Member
Mar 05, 2009 at 03:21 PM

Report Painter/Writer: Excel 2007 Integration

215 Views

Hi All,

I'm facing an issue with some reports I've prepared in Report Painter that are intergrated with Microsoft Excel. When I create a Report with more than 256 columns and execute it with Excel Integration it's giving an error: Run-time error '1004' .

When I debugged Visual Basic, it seems that the standard number of columns of Microsoft Excel is less than the number I required, this was OK for Microsoft Office 2003 version. However, with Microsoft Excel 2007 the number of available columns has increased to 16384. Hence it should work, but it's not!

Has anyone face this problem? Is this a suitable bug to report to SAP? Any idea or suggestions on how to deal with this?

Thanks!

Fede