Microsoft KB Archive/272886

= XL2001: Inserted List Contains Only the First Cell =

Article ID: 272886

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q272886



SYMPTOMS
In Microsoft PowerPoint for Mac or Microsoft Word for Mac, when you try to insert a list that has been created in Microsoft Excel 2001 for Mac, only the first cell in your list appears.



CAUSE
This behavior occurs if the list is created on any other than the first worksheet tab (Sheet1) in your workbook, or if the workbook is saved with any other than the first worksheet active (the currently visible worksheet).



WORKAROUND
To work around this behavior, create your list on the first worksheet tab (Sheet1) in your workbook, and make sure Sheet1 is the active sheet when you save your workbook. To do this, follow these steps:
 * 1) Start Excel, click the first worksheet tab (Sheet1) if it is not already selected, and then click List on the Insert menu.
 * 2) In the List Wizard - Step 1 of 3 dialog box, under Where you want to put the list?, click On existing worksheet.
 * 3) Follow the remaining steps in the List Wizard to create your list.
 * 4) After you create your list, save the Excel worksheet.
 * 5) Start Word or PowerPoint, and then on the Insert menu, click Object.
 * 6) In Word, click From File (in PowerPoint, click Create from file).
 * 7) In the Insert as Object dialog box, navigate to find the worksheet that you saved, and then click Insert.
 * 8) In the Insert Object dialog box, click OK.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.

Additional query words: off2001kb mac XL2001KB OFF2001SDOK

Keywords: kbbug kbpending KB272886

-

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

© Microsoft Corporation. All rights reserved.