Microsoft KB Archive/272872

= XL2001: Last Data Entry Is Undone When You Undo List Wizard Created by Autodetect =

Article ID: 272872

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q272872



SYMPTOMS
When you type data in a Microsoft Excel 2001 for Mac workbook, the program may automatically detect that you are managing a list and ask you if you want to convert the data to a list object. If you decide to convert the data, you can direct Excel to create the list object. However, if you attempt to undo the conversion and, therefore, click Undo List Wizard on the Edit menu (or COMMAND+Z), your last data entry is unexpectedly lost when the list reverts to a range.



WORKAROUND
To work around this issue, convert the list to a range instead of undoing the conversion of the range to a list. To do so, follow these steps:
 * 1) Select any cell inside the list object.
 * 2) On the List toolbar, click List, and then click Convert to Range. Click OK to confirm the conversion.



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

Additional query words: off2001kb mac XL2001KB

Keywords: kbbug kbnofix KB272872

-

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

© Microsoft Corporation. All rights reserved.