XL7: Exclamation Point Appears on Map After Moving Object

• Microsoft Excel for Windows 95, version 7.0

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.

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.

REFERENCES

For more information about updating your map when the exclamation point button appears, click the Index tab in Data Map Help, type the following text

   exclamation