XL7: Cannot Copy Worksheet That Contains a Map

 Last reviewed: September 13, 1996
Article ID: Q145571
The information in this article applies to:
  • Microsoft Excel for Windows 95, version 7.0, 7.0a

SYMPTOMS

In Microsoft Excel for Windows 95, if you use the Move Or Copy Sheet command on the Edit menu to copy a worksheet that contains a data map, you receive the following error message: 

   An error has occurred while opening a Microsoft Excel workbook.
After you click OK, a copy of the worksheet is created. The data exists in the copied worksheet, but the map container does not reflect the data that you mapped in the original sheet.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

You can use the Move Or Copy Sheet command on the Edit menu to move a worksheet containing a map. The message results only when you create a copy of the worksheet.

REFERENCES

For more information about Microsoft Data Map, click Answer Wizard in Help and type: 

   how do I create a map

KBCategory: kbusage kbprb
KBSubcategory:

Additional reference words: 7.00 7.00a



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.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.