Microsoft KB Archive/171584

= GRAPH: Error Message When You Import a Defined Range Name into Graph =

Article ID: 171584

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Graph 97
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Graph 2000
 * Microsoft PowerPoint 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft PowerPoint 97 Standard Edition
 * Microsoft Excel 98 for Macintosh
 * Microsoft Graph 98 Macintosh Edition
 * Microsoft PowerPoint 98 for Macintosh

-



This article was previously published under Q171584



SYMPTOMS
When you are working on a PowerPoint presentation, and you attempt to import a Microsoft Excel worksheet into Microsoft Graph and specify a named range from the workbook, you receive the following error message:

You must type a name defined in this file, or a range using the format A1:D5

If you click OK, you are returned to the Import Data Options dialog box. If you click Cancel in the Import Data Options dialog box, all existing data in the Graph object is lost. When you return to PowerPoint, there is no data or Graph placeholder.



WORKAROUND
To work around this problem, use either of the following methods.

Method 1
Paste the data from Microsoft Excel into Graph. Do not use the Paste Link command. If you do so, all existing data will be replaced.

Method 2
Specify the exact range of the data in your Microsoft Excel worksheet. For example, specify:

A1:D5



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbprb KB171584

-

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

© Microsoft Corporation. All rights reserved.