Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Open to a workbook (XP/2003)

    When first starting Excel is it possible to open to a specific workbook rather than the default blank workbook?
    Richard Spring

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

    Re: Open to a workbook (XP/2003)

    Anything stored in Excel's startup folder will be opened automatically when you start Excel. The default location of the folder 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 in Windows Explorer.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Open to a workbook (XP/2003)

    Thank you Hans:

    On my computer the <username> in Cocuments and Settings has several options:
    1. Administrator
    2. All Users
    3. default
    4. S405
    5. LogMeInRemoteUser

    Adminstrator inside the XLStart folder has PERSONAL.XLS
    All Users does not have an Excel folder
    The remainder are blank inside the XLStart folder.

    Which one should I use and how do I add the workbook to the XLStart folder. Do I drag and drop from the desktop or what.

    Thanks for the help
    Richard Spring

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

    Re: Open to a workbook (XP/2003)

    Since the Administrator one has a Personal.xls, I'd try that first.
    You can select the workbook in its original location, press Ctrl+X to cut it to the clipboard, then navigate to the XLStart folder and press Ctrl+V to paste the workbook. Drag-and-drop will also work.

    If you prefer, you can set an alternative startup folder:

    - In Excel, select Tools | Options...
    - Activate the General tab.
    - Enter the full path of the folder in the box labeled "At startup, open all files in".

    Warning: Excel will try to open *all* files in this folder, so don't use one of your regular document folders!

Posting Permissions

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