Microsoft KB Archive/274220

= Data maps are not supported in Excel for Mac =

Article ID: 274220

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q274220





SYMPTOMS
If you open a workbook that contains a data map, the data map is imported as a picture and appears in black and white.

If you double-click the data map, you receive the following error message:

Cannot start the source application for this object. There may not be enough memory available.



CAUSE
This behavior occurs because Microsoft Excel for Mac does not include support for data maps. Data maps are temporarily converted into pictures when you open them in Excel for Mac.



MORE INFORMATION
In Microsoft Excel for Windows 95, version 7.0, Microsoft Excel 97, and Microsoft Excel 2000 for Windows, you can create a data map in a worksheet by following these steps:   In a worksheet, select a range of cells that contains geographic data, such as country names or state names, and associated data, for example:      State            Population Maryland        5008060 North Carolina  7019142 Texas           18276706 Washington      5345474  In Excel 95 and Excel 97, click Map on the Insert menu or click the Map tool on the Standard toolbar. In Excel 2000, click Object on the Insert menu, and then click Microsoft Map in the list of objects. Draw the map on the worksheet. If the Multiple Maps Available dialog box appears, select the map that you want to use, and click OK.

The map appears in the worksheet.

However, if you open a workbook that contains a data map in Excel for Mac, the following dialog box appears:

Graphics Filter

Converting: Metafile

When the workbook opens, the map appears as a black and white picture. If you select the picture, the formula bar contains a formula similar to the following: =EMBED(&quot;MSMap.8&quot;,&quot;&quot;) If you save the workbook in Excel for Mac and then reopen the workbook in Microsoft Excel for Windows, the data map appears in color and opens for editing when you double-click it.

Additional query words: color Microsoft Map MacXLX Mac XLX XL2001

Keywords: kberrmsg kbnofix kbprb KB274220

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.