Article ID: 212245 - View products that this article applies to.
This article was previously published under Q212245
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
In Microsoft Excel, there is no built-in or simple way to share a custom sort/fill list that was created in Excel.
In Excel 2000, custom lists are more difficult to share because they are stored in the Microsoft Windows registry. In Microsoft Excel version 7.0, custom lists are stored in username.xlb; in version 5.0, they are stored in Excel5.xlb. Both of these files are stored in the \Windows folder.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To move a custom sort/fill list to another computer or user, you must export a Windows registry subkey. To locate and export the registry subkey that keeps the custom sort/fill list in Microsoft Excel, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
For more information about custom lists, click Microsoft Excel Help on the Help menu, type Create a custom fill series or sorting order in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For additional information about modifying the Windows registry, click the article number below to view the article in the Microsoft Knowledge Base:
136393For additional information about custom AutoFill lists, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/136393/EN-US/ )How to Modify the Windows Registry
(http://support.microsoft.com/kb/213796/EN-US/ )XL2000: How To Share a Custom AutoFill List
Article ID: 212245 - Last Review: November 5, 2003 - Revision: 3.1
Contact us for more help