Microsoft KB Archive/924120

Knowledge Base

Error message when you select a custom range in an Excel worksheet to try to link to shapes in Visio 2007: "The selected worksheet range cannot be imported"

Article ID: 924120

Article Last Modified on 10/15/2007

---

APPLIES TO

• Microsoft Office Visio Professional 2007

---

SYMPTOMS

When you select a custom range in a Microsoft Excel worksheet and then try to import data to link to shapes in a Microsoft Office Visio 2007 drawing, the data is not imported. Additionally, you receive the following error message:

The selected worksheet range cannot be imported.
Make sure the worksheet name does not contain leading spaces or any of the following reserved characters:
Accent ("`"), exclamation ("!"), or pound ("#").

CAUSE

This issue may occur when the worksheet name contains any of the following characters:

• Leading spaces
• Number sign
• Exclamation point
• Acute accent
• Any low ASCII character (0 through 31)

WORKAROUND

To work around this issue, rename the worksheet in Excel. When you rename the worksheet, do not use any of the characters that are listed in the "Cause" section.

Additional query words: visio2007 visio2k7 visio12 vso2007 vso2k7 vso12

Keywords: kberrmsg kbtshoot kbimport kbprb kbexpertisebeginner kbdataaccess KB924120

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.