Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Excel starup page (Excel 2003 and 2007)

    For some reason I don NOT have a blank spreadsheet on the screen when Excel starts. If I create one ie book.xls and put it in the startup directory. It sort of works. However if I start a 2nd instance of excel then it says book1.xls is blocked and can only be opened in read mode etc.
    Any help appreciated
    J Klein

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

    Re: Excel starup page (Excel 2003 and 2007)

    Why would you want to start a second instance of Excel?

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Excel starup page (Excel 2003 and 2007)

    because sometimes a program causes excel to load in the background.
    Is there a standard startup page/file where you don't have to load one manually.
    If you load 3 instances of word it loads a beginning doc and then another doc etc without saying the file is locked.
    Jerome

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

    Re: Excel starup page (Excel 2003 and 2007)

    If you have nothing in your XLStart folder (except perhaps a personal macro workbook Personal.xls, that is a special case), Excel should start with a blank workbook that is not based on a specific file but just on your default settings in the General tab of Tools | Options...

    If the blank workbook is suppressed, it could be because you start Excel using a shortcut that has an /e or /s switch in its target. Check the properties of the shortcut you use to start Excel.

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Excel starup page (Excel 2003 and 2007)

    Hi Hans.
    No have tried to lauch 2003 and 2007 many different ways including windows run excel.exe and still not blank workbook
    By the ways my / our sincerest thanks for getting the lounge back up and running.
    Jerome

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel starup page (Excel 2003 and 2007)

    See Jan Karel's Systematic Approach to Behavioral Problems in XL. In particular, try the items that have to do with XLSTART and "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver
    Legare Coleman

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel starup page (Excel 2003 and 2007)

    If you click the Window menu, is the item called "Unhide" enabled? If so click it. If any workbook other than personal.xls shows up in the dialog, this prevents your empty workbook from appearing.

    With Excel 2007 I seem to recall that a personal.xls from another Excel version may interfere with this process and actually prevent the empty workbook from appearing.(Excel 2007 expects a file called personal.xlsb)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Excel starup page (Excel 2003 and 2007)

    This helped alot
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation worked well and cleared the problem. But there are no hidden files or addins. So not certain why this is working
    Jerome

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel starup page (Excel 2003 and 2007)

    The fact that that works indicates it is an addin or a file in XLSTART that is causing havoc. The automation switch tells Excel to ignore addins and XLSTART folders.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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