XL7: Exclamation Point Appears on Map After Moving 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.