+ Reply to Thread
Results 1 to 3 of 3

Automatically Opens 2x Workbooks

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    1

    Automatically Opens 2x Workbooks

    Hi :-) When I open an excel file (2007), it automatically opens 2x workbooks (the one I selected and a blank workbook called PERSONAL).
    How do I stop it from doing this? It never used to - I think I have somehow requested it whilst playing with Excel for a TAFE exam...

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Automatically Opens 2x Workbooks

    Try hiding the Personal workbook (View>>Hide) then close Excel and say yes to saving changes to the Personal workbook.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Automatically Opens 2x Workbooks

    It could also have something to do with where you set up your default "save" folder, and what other excel files you have in there? I had a similar (very frustrating) situation, until i changed the "save" folder, and made sure i had no excel files in there
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1