XL: Err Msg: Microsoft Data Map Is Not Installed

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

When you attempt to insert a map in Microsoft Excel, you may receive one of the following error messages, depending on the version of Microsoft Excel you are using:

Microsoft Excel 97

   Microsoft Map is not installed. To use Microsoft Map, you must run
   Setup and select Microsoft Map.

Microsoft Excel version 7.0

   Microsoft Data Map is not installed. To use Data Map you must run Setup
   and choose to add Microsoft Data Map.

CAUSE

There are two possible causes for this error message:

• Microsoft Data Map/Microsoft Map was not chosen during Setup.

      -or-
  

• The path to the Microsoft Data Map/Microsoft Map directory in the Windows registry is incorrect.

RESOLUTION

Method 1

If Microsoft Data Map/Microsoft Map was not selected during Microsoft Excel Setup, use the following steps to run Setup in maintenance mode:

1. Click the Windows Start button, point to Settings, and then click Control Panel.

2. In Control Panel, double-click Add/Remove Programs.

3. In the Add/Remove Programs Properties dialog box, double-click the entry for Microsoft Office on the Install/Uninstall tab.

4. In the first Microsoft Office dialog box that appears, click Add/Remove.

5. In the next dialog box, click Microsoft Excel. Make sure the check box next to Microsoft Excel does not clear itself. If it does, click the Microsoft Excel check box.

6. Click the Change Option button, and then click the check box for Microsoft Data Map/Microsoft Map. Click OK.

7. Click Continue.

Method 2

If the Microsoft Data Map/Microsoft Map path in the Windows registry is incorrect, rerun the Microsoft Office Setup using the /y switch. To do this:

1. Quit any Microsoft Office programs that are currently running, including the Office Shortcut bar.

2. In Windows Explorer, open the folder in which you have the Setup program for Microsoft Office.

3. On the Start menu, click Run, and delete anything in the Open box.

4. Drag the Shortcut for Setup from the folder in Step 2 to the Run dialog box.

   The full path to the Setup shortcut appears in the Run dialog box. For example, if you dragged the Office Setup shortcut to the Run dialog box, the command line in the Open box resembles the following:

         c:\msoffice\setup.lnk
   

5. Modify the command line in the Open box by adding " /y", without the quotation marks, to the end of the command line. So, for example, the command line would resemble the following:

         c:\msoffice\setup.lnk /y
   

   NOTE: Make sure there is a space separating the path to the Setup shortcut and the /y switch.

6. In the Run dialog box, click run. This starts the Setup program in maintenance mode.

7. In the Setup dialog box, click Reinstall.

8. When Setup is finished, click OK.

Method 3

An alternate method to correct a misdirected path pointer is to separately start the Microsoft Data Map/Microsoft Map program. This enables you to manually enter the path to the Microsoft Data Map/Microsoft Map program. To do this, start Windows Explorer and locate the folder where Microsoft Data Map/Microsoft Map is installed. By default the location is:

   <X>:\Program Files\Common Files\Microsoft Shared\Datamap