Issue with exporting data to the Excel format.

Email It to Me Print this Page
Symptoms You are getting error like the following when trying to export report to the Excel format:

User-added image
 
Cause Microsoft Excel has a limit for total number of characters that a cell can contain (32,767). (http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx) If some report fields contain more that 32,767 characters it cannot be exported to the Excel format.
Resolution In order to resolve an issue you need to find out fields that contain more 32,767 characters and get the list of changes that produce so much data in one cell. Then you will need to exclude such changes from being reported with omit files located in the product installation directory. For example, if it is a change to some AD attribute you can omit it with omitproplist.txt file located in the 
product installation directory (C:\Program Files (x86)\NetWrix\AD Change Reporter Full Version).

To be able export historical data to the Excel format you will need to delete problematic rows from the database.
For example, 
if it is a change to some AD attribute, you can use the following SQL query to delete all changes to this attribute.

USE NetWrix_AD_Change_Reporter; 
GO 
Delete Changes 
FROM Changes INNER JOIN PropChanges 
ON Changes.ChangeId = PropChanges.ChangeId 
WHERE PropChanges.Propname like '<attribute name>' 
Was this information helpful?