Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Standard 'new' workbook (XL XP/2002)

    Hi all,

    I've had a search of the excel forum but can't find what I know is there somewhere...

    I've just reinstalled XP & Office and I recall there was a file (newbook.xls??) you could put in a startup directory so that opening excel or doing a File|New brought up a custom workbook.

    Can anyone give me a pointer or post number...

    Thanks,

    Stuart

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Standard 'new' workbook (XL XP/2002)

    Create a workbook with all the settings you like. Save it as an Excel template named Book.xlt, and also save it as a template named Sheet.xlt. Store both in your XLSTART folder; under Windows XP its location is

    Cocuments and Settings<username>Application DataMicrosoftExcelXLSTART

    Note: Application Data is a hidden folder, so you must display hidden files and folders in order to see it.

    Book.xlt will be used as the standard new workbook, and Sheet.xlt will be used as the standard new worksheet (Insert |Worksheet)

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Standard 'new' workbook (XL XP/2002)

    Hans, you're a legend...

    Exactly what I needed.

    Thanks,

    Stuart

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Standard 'new' workbook (XL XP/2002)

    Hans,

    Another addendum !

    It might be a good idea to ensure Sheet.xlt contains just one worksheet, as otherwise inserting a worksheet would result in multible sheets being added.

    Andrew

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Standard 'new' workbook (XL XP/2002)

    Ah yes, I forgot about that, since my own setup specifies that a new workbook contains only one worksheet. Thanks again!

Posting Permissions

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