Export to Excel Format
Hi All,
When i export to Excel Format which Exceeds 65K Rows the Subsequent Reports has to be Rendered to a New Page in Excel 2005.
Is there any method we can achieve this Functionality.???
Quick Response will be Highly Useful.
Thanks,
RakeshRakesh M J
May 6th, 2011 3:31am
Hi Rakesh,
This is a limitation of excel 2003. As of now, only workaround is to use page brakes in report, which will create saperate worksheets.
For SQL server deanli, it will export to XML format office document, which will allow more then 65K rows.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 3:37am