# Export into Excel **URL:** \ **Category:** Technical Forum\ **Created:** [July 22, 2013, 8:52am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158 "2013-07-22T08:52:03Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![nitinagrawal003](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nitinagrawal003](https://www.dynamicsuser.net/u/nitinagrawal003)\ **Post date:** [July 22, 2013, 8:52am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/1 "2013-07-22T08:52:03Z")
**When i export a report in excel from nav2013, it is popping up error of excedding 65k rows…msoffice 2007 version** **what do i do if i have a report which has 3lac rows?** ---
**Author:** ![nitinagrawal003](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nitinagrawal003](https://www.dynamicsuser.net/u/nitinagrawal003)\ **Post date:** [July 22, 2013, 9:02am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/2 "2013-07-22T09:02:05Z")
ERROR–Rendering output for the report failed and the following error occurred : Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 102572, Max Rows: 65536 ---
**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\ **Post date:** [July 22, 2013, 9:13am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/3 "2013-07-22T09:13:15Z")
Excel 2007 maximum row limit is 65536 you need to have higher version of excel … ---
**Author:** ![nitinagrawal003](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nitinagrawal003](https://www.dynamicsuser.net/u/nitinagrawal003)\ **Post date:** [July 22, 2013, 10:08am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/4 "2013-07-22T10:08:53Z")
thank you for the reply, if i create a new excel, it shows me 1 million rows… ---
**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\ **Post date:** [July 22, 2013, 10:15am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/5 "2013-07-22T10:15:16Z")
You are probably set to save in Compatibility Mode. Click on the icon in the upper left corner of your worbook.–\>Click on Excel Options–\>Click on Save Under Save Files in this Format, change to Excel Workbook (\*.xlsx) Try to save your file in .xlsx format. ---
**Author:** ![nitinagrawal003](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nitinagrawal003](https://www.dynamicsuser.net/u/nitinagrawal003)\ **Post date:** [July 25, 2013, 8:51am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/6 "2013-07-25T08:51:43Z")
[http://dynamicsuser.net/forums/p/52980/276575.aspx](http://dynamicsuser.net/forums/p/52980/276575.aspx) this error is also in msoffice 2010… Can i do something like, after 65k rows, it should create a new excel file. Please suggest me … and how.? ---
**Author:** ![Andre\_DDB](https://avatars.discourse-cdn.com/v4/letter/a/43a26b/32.png) [@Andre\_DDB](https://www.dynamicsuser.net/u/Andre_DDB)\ **Post date:** [July 25, 2013, 9:10am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/7 "2013-07-25T09:10:40Z")
Do you really need an Excel file directly? An idea would be to write your data in a text file and to open that text file in Excel afterwards. ---
**Author:** ![nitinagrawal003](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nitinagrawal003](https://www.dynamicsuser.net/u/nitinagrawal003)\ **Post date:** [July 25, 2013, 11:50am UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/8 "2013-07-25T11:50:58Z")
same thing,i am working on… i am trying to export a report in text as there is no office installed on server , that’s why i saved it on server as .xls and copy to my computer… but it is giving the error, … ---
**Author:** ![Andre\_DDB](https://avatars.discourse-cdn.com/v4/letter/a/43a26b/32.png) [@Andre\_DDB](https://www.dynamicsuser.net/u/Andre_DDB)\ **Post date:** [July 25, 2013, 12:14pm UTC](https://www.dynamicsuser.net/t/export-into-excel/47158/9 "2013-07-25T12:14:38Z")
I’m talking about the Outstream function ([http://msdn.microsoft.com/en-us/library/dd301446.aspx](http://msdn.microsoft.com/en-us/library/dd301446.aspx)) to write a text file. There shouldn’t be a check regarding the max rows.