Skip to Content
0
Former Member
Mar 16, 2010 at 01:42 PM

BO and Excel 2007 row limitations

28 Views

I have a bo user who is trying to save 500K rows of data from BO into Excel 2007. She wants to be able to see ALL of the data on one tab in Excel. However, when I save the data from BO Webi Xi3 into Excel 07, the data is split into multiple tabs 1, 2, 3, etc. Is there a way to get all of the 500K rows of data on one tab? Excel 2007 has a 1048576 row limitation.

Thanks.