DOCUMENT:Q231521 14-SEP-2001 [automap] TITLE :MapPoint 2000: Unexpected Data Is Exported to Excel PRODUCT :Microsoft Automap PROD/VER:WINDOWS: OPER/SYS: KEYWORDS:kbinterop kbtool kbimu ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft MapPoint 2000 ------------------------------------------------------------------------------- SYMPTOMS ======== When you use Microsoft MapPoint 2000 to display demographic data, the Microsoft Excel workbook you create if you export the map to Excel may contain more data than is displayed on the map. CAUSE ===== This behavior can occur if either of the following conditions are true: - You use the Data Mapping wizard to filter the data you want to display on the map. - You skip one or more columns of data when you import the data you want to display on the map. RESOLUTION ========== To work around this issue, delete any column of data from the workbook that does not contain demographic data portrayed on the map. To do this: 1. Select the column you want to delete. 2. On the Edit menu, click Delete. Repeat this step for each column you want to delete. STATUS ====== This behavior is by design. Additional query words: mp2000 columns excessive many more ====================================================================== Keywords : kbinterop kbtool kbimu Technology : kbHomeProdSearch kbMapptSearch kbMapPoint2000 Version : WINDOWS: Issue type : kbprb ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.