Microsoft KB Archive/171584

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:35, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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