XL2001: Inserted List Contains Only the First Cell (272886)
The information in this article 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:
- Start Excel, click the first worksheet tab (Sheet1) if it is not already selected, and then click List on the Insert menu.
- In the List Wizard - Step 1 of 3 dialog box, under Where you want to put the list?, click On existing worksheet.
- Follow the remaining steps in the List Wizard to create your list.
- After you create your list, save the Excel worksheet.
- Start Word or PowerPoint, and then on the Insert menu, click Object.
- In Word, click From File (in PowerPoint, click Create from file).
- In the Insert as Object dialog box, navigate to find the worksheet that you saved, and then click Insert.
- In the Insert Object dialog box, click OK.
STATUSMicrosoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbbug KB272886 |
|---|
|