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.
- Open Regedit - Open the registry editor by clicking on the menu: Start > Run > Regedit.exe
- 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
- Edit Rows - Choose TypeGuessRows registry and edit the value to 0.
|