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:
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