Microsoft KB Archive/924120

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

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 (&quot;`&quot;), exclamation (&quot;!&quot;), or pound (&quot;#&quot;).



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 &quot;Cause&quot; section.

Additional query words: visio2007 visio2k7 visio12 vso2007 vso2k7 vso12

Keywords: kberrmsg kbtshoot kbimport kbprb kbexpertisebeginner kbdataaccess KB924120

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.