Rows or columns of data might be missing after importing Microsoft Excel data into SAS Enterprise Guide. To attempt to circumvent the problem, use the following steps to change a registry setting:

1. Select Start ► Run. Enter the command Regedit and click OK.
2. Expand HKEY_LOCAL_MACHINE.
3. Expand to Software\Microsoft\Jet\4.0\Engines.
4. Select Excel.
5. Right-click on TypeGuessRows and choose Modify.
6. Change the value to 0 (Zero).

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Enterprise Guide 4.1 is available at: