KnowledgeBase - Unable to export Webtrends' reports in Microsoft Word or Excel format when Microsoft Office is installed on the network
Article

Unable to export Webtrends' reports in Microsoft Word or Excel format when Microsoft Office is installed on the network

« Go Back
Products
Webtrends Legacy Products
Symptoms
Cause
Resolution
For products:
Webtrends Enterprise 7.x

Webtrends Professional 7.x
Webtrends Small Business 7.x
Webtrends Reporting Center 6.x

Last modified: 1/1/2011

Situation:
Microsoft Office is installed on a network share rather than installed locally on the client machine. When this occurs, the Windows registry settings that are normally queried are not available and Webtrends is unable to export reports in Microsoft Word or Excel format.

Solution:
In order to resolve this issue, modify the Webtrends Report Exporter DocUtil.properties file in order to to specify the location and version of the Word and Excel programs:

1. Open the DocUtil.properties file in the installation directory. The DocUtil.properties file is located in the following folders depending on which version of the software is being used.

Default path for Webtrends 7 Report Exporter Path:
C:\Program Files\Webtrends Report Exporter

Default path for Webtrends 6.1 Document Utility
C:\Program Files\Webtrends Document Utility II

2. Modify the DocUtil.properties and add the following lines to the bottom of the file for the version of Microsoft Office being used:

Microsoft Office 2003:
Excel.AltExePath= x:\\full\\path\\to\\excel.exe Excel.AltVersion = 11 Word.AltExePath =x:\\full\\path\\to\\winword.exe Word.AltVersion = 11


Microsoft Office XP:
Excel.AltExePath= x:\\full\\path\\to\\excel.exe Excel.AltVersion = 10 Word.AltExePath =x:\\full\\path\\to\\winword.exe Word.AltVersion = 10


Microsoft Office 2000:
Excel.AltExePath= x:\\full\\path\\to\\excel.exe Excel.AltVersion = 9 Word.AltExePath =x:\\full\\path\\to\\winword.exe Word.AltVersion = 9


3. Save the file.

After this these changes have been made, attempt to export reports to these formats once again.
 
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255