Microsoft KB Archive/133712

= XL7: Exclamation Point Appears on Map After Moving Object =

PSS ID Number: 133712

Article Last Modified on 10/20/2000

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q133712



SYMPTOMS
In Microsoft Excel, if you move a drawing object or OLE object on your worksheet so that it overlaps any part of the range of cells that you used to create a Microsoft Data Map object, the exclamation point button appears in the upper-left corner of the map object.



CAUSE
This behavior occurs under the following circumstances:


 * You create a map object using data contained in cells on your worksheet
 * You then move a drawing object or OLE object including the map object itself so that it covers a portion of the range that contains the map data.

For example, if you create a map from data in cells A1:B3 on your worksheet, the exclamation point button appears on your map if you move the map so that it overlaps any part of the range A1:B3.

This behavior occurs because when the map object is refreshed, it detects that the range that you used to create the map has changed (because an object has been moved within this range), even though the actual data has not changed. The exclamation point button in the corner of the map indicates that the map may need to be updated. Normally, this button only appears when you change the data used in your map. However, this button also appears if you move an object so that it covers the data used in your map.

Note that this behavior also occurs when you move the object so that it no longer covers the range of data used to create the map.



RESOLUTION
To remove the exclamation point button from the map object, activate the map object, and click the exclamation point button, or click Refresh on the Map menu.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

