Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2000 Start Up (2000 SP-2)

    I am stumped by this problem. I have searched through MSKB knowlege Bases to no avail. I hope someone can help me.

    My copy of Excel 2000 on Win98SE does not open with a blank workbook (Book1). It does with a /s switch. I have tried steps in MSKB Q280504, but nothing helped. How do I get back Excel to start up with a new workbook?

    Thanks.

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

    Re: 2000 Start Up (2000 SP-2)

    Try one of these, maybe a solution is within them:

    Try opening Excel without any addins or hidden workbooks:

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation

    Quotes mandatory, Note you may have to change the path.

    If your error disappears, there is either an add-in or a (hidden) workbook that is loaded upon XL's start, which bothers you.

    - Try locating the XLSTART directory, move everything from there.
    - In XL: Tools, Addins, note the ones checked and uncheck them one at the time, each time restarting XL
    - In XL, Tools, options, general. Check if a path is entered after "Alternate startup file location". Clear it.

    Also, you might try:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 Start Up (2000 SP-2)

    Jan:

    I ran
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation

    This opened a blank workbook.

    I don't have any add-ins.

    The path to alternate startup location is empty.

    I ran
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

    This didn't help.

    Is there a way to refresh Excel's cache or preference somewhere to restore it to default state?

    Thanks,
    Keitaro Matsuoka

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

    Re: 2000 Start Up (2000 SP-2)

    The fact that running it with the automation switch gets the behaviour you need indicates that some workbook is loaded at startup of excel that causes it NOT to load an empty workbook.

    It means you probably have a file in the XLSTART directory that causes this. Try moving the files out of that location and see which one causes this.

    To see if any files have been loaded, try looking at the project explorer in the Visual Basic Editor (Alt-F11, left pane of your screen, or choose View, project explorer). If none are listed, well, than we have a problem.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 Start Up (2000 SP-2)

    An interesting discovery:

    I randomly picked an Add-in, say, Analysis Toolpak, and restarted Excel. Voila. Excel started with a new workbook. However, if I leave everything unchecked in the Add-ins, it doesn't open with a new workbook.

    Also, in the same scenario, VB Editor shows 6 sheets open, but none without any add-ins. What's going on??

    Thanks.

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

    Re: 2000 Start Up (2000 SP-2)

    When does the VBE show 6 sheets? If you have an empty workbook or if you don't?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    New Lounger
    Join Date
    Jun 2002
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 Start Up (2000 SP-2)

    Sorry for my sloppy last time.

    If I select any add-in, Excel opens with a blank workbook. VBE shows 6 sheets. If I deselect all add-ins, Excel does NOT open with a blank workbook, and VBE shows no workbook/worksheets.

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

    Re: 2000 Start Up (2000 SP-2)

    OK, a few checks if I may.

    - Have you checked the commandline inside the link you use to open XL? Does it contain any switches?
    - Open XL, Tools, Options, General (need to have at least one workbook open to be able to do that). Is Ignore other apps checked? Uncheck.
    - If you start XL and no window is there, can you choose Window, Unhide (you shouldn't since there are no projects in the VBE, but who knows...)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    New Lounger
    Join Date
    Jun 2002
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 Start Up (2000 SP-2)

    - Have you checked the commandline inside the link you use to open XL? Does it contain any switches?

    There is no switch at all.

    - Open XL, Tools, Options, General (need to have at least one workbook open to be able to do that). Is Ignore other apps checked? Uncheck.

    Unchecked.

    - If you start XL and no window is there, can you choose Window, Unhide (you shouldn't since there are no projects in the VBE, but who knows...)

    I cannot choose Unhide. It's grayed out.

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

    Re: 2000 Start Up (2000 SP-2)

    This is getting more and more mysterious.

    Another few hunches then.

    - what happens if you press and hold the shift key when you launch Excel?

    - try if renaming your toolbar customisation file (called *.xlb) to *.OLD helps

    - try this in order:

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Unregserver

    Quotes mandatory, Note you may have to change the path.

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

    I know you did the last one before, but maybe the sequence above makes XL reconsider...

    Finally (sorry if I repeat myself) have you checked *all* possible directories called XLSTART (there may be more than just one!) for any files in them?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    New Lounger
    Join Date
    Jun 2002
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 Start Up (2000 SP-2)

    - what happens if you press and hold the shift key when you launch Excel?

    A new workbook is opened. The toolbars are on the same "line."

    - try if renaming your toolbar customisation file (called *.xlb) to *.OLD helps

    Did not help.

    - try this in order:

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Unregserver

    Quotes mandatory, Note you may have to change the path.

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

    Did not help.

    I know you did the last one before, but maybe the sequence above makes XL reconsider...

    Finally (sorry if I repeat myself) have you checked *all* possible directories called XLSTART (there may be more than just one!) for any files in them?

    There are two in my c drive. They are both empty. I don't think there is any hidden file there either.

    The only remedy so far is that I have to have at least one add-in selected in order to start with a new workbook.

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

    Re: 2000 Start Up (2000 SP-2)

    I am truly stumped.

    May I suggest a clumsy workaround?

    Lets create a personal.xls file:

    - Tools, macro, record macro. Make sure to put it in the Personal macro workbook.
    - do something trivial
    - stop recording

    and create something in the Thisworkbook mmodule that runs each time you open this workbook called Personal.xls (hidden workbook that will reside in one of your xlstart folders):

    Workbook_Open is an "event procedure" and needs to go in the module of the ThisWorkbook object of Personal.xls.

    Alt+F11 to the VB editor
    In the project explorer window double-click the ThisWorkbook entry under Microsoft Excel Objects.
    In the code window which should now be showing you the module for ThisWorkbook:
    - select Workbook from the left hand dropdown at the top of the window
    - select Open from the right hand dropdown [may have happened automatically]
    - type your code between the lines
    Private Sub Workbook_Open()
    and
    End Sub
    which will have been generated automatically.

    Have it look like this:

    Private Sub Workbook_Open()
    Workbooks.Add
    End Sub

    Remove all other lines of code that are there which you don't need.
    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
  •