Export to Excel

[Fran]

When I export to excel, the excel list stops with 10,000 rows. I use
office 2007 and I was under the impression there were much greater limits on
the number of rows allowed in an excel report.

Does anyone know how to reconfigure so that all leads/ or contacts will
export into excel without limiting out at 10,000 rows.
Thanks

[Pete]

There is a chnage you can make - available on a few of the blogs -
google is your friend - can't remember off the top of my head

Post by Fran
When I export to excel, the excel list stops with 10,000 rows. I use
office 2007 and I was under the impression there were much greater limits on
the number of rows allowed in an excel report.
Does anyone know how to reconfigure so that all leads/ or contacts will
export into excel without limiting out at 10,000 rows.
Thanks

[Jukka Majander]

Hi

http://support.microsoft.com/kb/911395/enus$


1. On CRM server Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
3. On the Edit menu, point to New, click DWORD Value, type
maxrecordsforexporttoexcel, and then press ENTER.
4. Double-click maxrecordsforexporttoexcel, click Decimal, type the maximum
number of records that you want to export to an Excel worksheet, and then
click OK.
5. Close Registry Editor.
6. IISRESET

Jukka Majander

Post by Pete
There is a chnage you can make - available on a few of the blogs -
google is your friend - can't remember off the top of my head

Post by Fran
When I export to excel, the excel list stops with 10,000 rows. I use
office 2007 and I was under the impression there were much greater limits on
the number of rows allowed in an excel report.
Does anyone know how to reconfigure so that all leads/ or contacts will
export into excel without limiting out at 10,000 rows.
Thanks

[CRM Microsoft]

http://adriannair-crm40.blogspot.com/

CRM 4.0 Increase the Maximum Records exported to Excel
Change from 10,000 to 65,000 (note: Excel has limitation of 65,536 rows)
Use the <organization>_MSCRM database

1. Check the current limit
SELECT
[MaxRecordsForExportToExcel]
FROM <organization>.[dbo].[OrganizationBase]

Default result: 10,000

2. Update
UPDATE
<organization>.[dbo].[OrganizationBase]
SET [MaxRecordsForExportToExcel] = '65000'

$25 is all it takes? to change your life!

Go see the 2 Minute Movie that is causing herds of
people to pull their wallets out on demand, buy our
simple system and begin upgrading you financial future
within days

http://www.retirein10weeks.com

Post by Fran
When I export to excel, the excel list stops with 10,000 rows. I use
office 2007 and I was under the impression there were much greater limits on
the number of rows allowed in an excel report.
Does anyone know how to reconfigure so that all leads/ or contacts will
export into excel without limiting out at 10,000 rows.
Thanks

Post by Pete
There is a chnage you can make - available on a few of the blogs -
google is your friend - cannot remember off the top of my head

Post by Jukka Majander
Hi
http://support.microsoft.com/kb/911395/enus$
1. On CRM server Click Start, click Run, type regedit, and then click OK.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
3. On the Edit menu, point to New, click DWORD Value, type
maxrecordsforexporttoexcel, and then press ENTER.
4. Double-click maxrecordsforexporttoexcel, click Decimal, type the maximum
number of records that you want to export to an Excel worksheet, and then
click OK.
5. Close Registry Editor.
6. IISRESET
Jukka Majander

Post by gherbstman
1. Log-in to the SQL Server where the <Organization_Name>_MSCRM database is
stored
2. Open the OrganizationBase table
3. Find the Column: MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
--
Gary Herbstman
Byte Solutions, Inc.
http://bytesolutions.com

Post by LeonTribe
is
use
ts
If its a dynamic worksheet you can also change the query directly to
http://leontribe.blogspot.com/2009/01/reporting-in-crm-with-excel.html
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
Submitted via EggHeadCafe
SQL Operations on a Text File with ADO.NET
http://www.eggheadcafe.com/tutorials/aspnet/37ed9e1b-c5de-4c0b-afbe-d8f78f9a6ecf/sql-operations-on-a-text-file-with-adonet.aspx

[gherbstman]

1. Log-in to the SQL Server where the <Organization_Name>_MSCRM database is
stored
2. Open the OrganizationBase table
3. Find the Column: MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
--
Gary Herbstman
Byte Solutions, Inc.
http://bytesolutions.com

Post by Fran
When I export to excel, the excel list stops with 10,000 rows. I use
office 2007 and I was under the impression there were much greater limits
on the number of rows allowed in an excel report.
Does anyone know how to reconfigure so that all leads/ or contacts will
export into excel without limiting out at 10,000 rows.
Thanks

[LeonTribe]

Post by gherbstman
1. Log-in to the SQL Server where the <Organization_Name>_MSCRM database is
stored
2. Open the OrganizationBase table
3. Find the Column:  MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
--
Gary Herbstman
Byte Solutions, Inc.http://bytesolutions.com

When I  export to excel, the excel list stops with 10,000 rows.  I use
office 2007 and I was under the impression there were much greater limits
on the number of rows allowed in an excel report.
Does anyone know how to reconfigure so that all leads/ or contacts will
export into excel without limiting out at 10,000 rows.
Thanks

If its a dynamic worksheet you can also change the query directly to
remove the '10000' clause. see here for details:

http://leontribe.blogspot.com/2009/01/reporting-in-crm-with-excel.html

Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/