MS Excel Configuration

Overview
Definedoc exports data definition to Excel through the use of SAS Access to PC File formats.  In some installations, Excel needs to be configured to handle long text such as in the case of a long comment.  The following will update the registry for Excel to handle multiple lines.

  1. Open Regedit - Open the registry editor by clicking on the menu: Start > Run > Regedit.exe
  2. Find Key - Navigate to or search for the correct key.   You can search for excel or just navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
  3. Edit Rows - Choose TypeGuessRows registry and  edit the value to 0.

    Definedoc - DEFINE.XML Software,  Meta-Xceed Inc.© 2009
Bookmark and Share