Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: When I open excel, it always opens as a personal worksheet

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I open the excel program. A personal worksheet opens first than a blank worksheet.

    When I save any type of macros, it always saves them with a personal extention.

    How do I change this setting so Excel just opens with one worksheet?

    Thanks
    Mike

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    look in your xlstart folder - the personal template is probably in there. if you remove it things should go back to normal.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks anno! I found the folder, delted the personal worksheet and now it works fine.

    Thanks

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    jbyrne: Be careful.

    If you're saving macros to use in ANY file, they're stored in the personal.xls file. If you've deleted it, any macros in it will no longer be available to you.

    The personal.xls file is usually hidden, but it sounds as if yours is not.

    You can close Excel, and restore that file from your recycle bin. Now, open Excel. Go to the personal.xls workbook. Hit Window-Hide. And then you should only see *book1*. Then close Excel. You'll be asked if you want to save personal.xls, and you DO.

    Now, not only should Excel work properly, but your macros will be available too.

    For more info on XLSTART and startup folders, check this out:

    http://www.thewordexpert.com/excel.htm#StartupFolders

    Hope this helps!
    Good work, anno!
    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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