Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171584

From BetaArchive Wiki
Knowledge Base

Article ID: 171584

Article Last Modified on 8/17/2005


  • 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


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.


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:



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

Keywords: kbprb KB171584