Microsoft KB Archive/212245

= XL2000: Unable to Share Custom Lists =

Article ID: 212245

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
In Microsoft Excel, there is no built-in or simple way to share a custom sort/fill list that was created in Excel.



CAUSE
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 .xlb; in version 5.0, they are stored in Excel5.xlb. Both of these files are stored in the \Windows folder.



RESOLUTION
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:

 Quit Microsoft Excel. On Start menu, click Run. In the Run box, type regedit, and then click OK. In the left pane of Registry Editor, locate the following subkey (folder):

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options

 Select the subkey listed in step 4. Back up the registry entry you currently have for this registry subkey. On the Registry menu, click Export Registry File. In the File name box, type a name for your backup, and then click Save.</li> In the right pane of Registry Editor, click the first item in the Name column, and then hold down SHIFT while you click the last item in the Name column.

This selects all entries for the subkey specified in step 4.</li> Hold down CTRL, and then click SmartList in the Name column.

This clears the selection of just this item.</li> Click Delete on the Edit menu. Click Yes to confirm deleting the values. After deleting items, if you see the error message

Unable to delete all specified values

click OK.

This removes all other keys except the intended item and the default key.</li> On the Registry menu, click Export Registry File. In the File name box, type a name for this registry file, and then click Save.

NOTE: You must choose a different name than the name you used in step 6.

This is the registry file that you give to the computers that will share the custom sort/fill list.</li> Reset your registry setting for the key specified in step 4. On the Registry menu, click Import Registry File, and in the Import Registry File dialog box, double-click the registry file that you saved in step 6.</li> On the Registry menu, click Exit.</li> Copy the registry file that you saved in step 10 to a floppy disk or to a shared network directory.</li> On the computer to which you want to copy the custom sort/fill list, repeat steps 2-5.</li> On the Registry menu, click Import Registry File, and then locate the registry file that you copied in step 13.</li> On the Registry menu, click Exit.</li> Start Microsoft Excel.</li> Click Options on the Tools menu, and then click the Custom Lists tab.

The custom list that you created is displayed under Custom lists.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="references_section">