GRAPH: Error Message When You Import a Defined Range Name into Graph (171584)
The information in this article applies to:
- Microsoft Graph 97
- Microsoft Excel 2000
- Microsoft Graph 2000
- Microsoft PowerPoint 2000
- Microsoft Excel 97 for Windows
- Microsoft PowerPoint 97 for Windows
- Microsoft Excel 98 Macintosh Edition
- Microsoft Graph 98 Macintosh Edition
- Microsoft PowerPoint 98 Macintosh Edition
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:
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbprb KB171584 |
|---|
|