Results 1 to 3 of 3

Thread: Excel sort list

  1. #1
    daniel_chiu
    Guest

    Excel sort list

    I want to know how to back up (or copy to another computer) the customs sort list I stored under Tools - Options - Custom List.
    I do not know where/how the sort list is kept, and I need to re-create it every time when I have a new instalation of Excel.
    Thanks for any idea.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: Excel sort list

    Hi Daniel
    Check out microsoft knowledge base:
    Article ID: Q155208

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q155/2/08.asp?LN=EN-US&SD=gn&FR=0&qry=Custom>http://support.microsoft.com/support/kb/ar...FR=0&qry=Custom</A> Lists&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97

    Cheers
    Geof

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    64
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel sort list

    When you customise the toolbar Excel stores this information in the default worksheet, "BOOK.XLS" which is usually in the XLSTART folder in your Office setup. I guess a customised sort list that is attached to your toolbar would be kept here too. Worth a try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •