+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : How to stop multiple workbooks from opening

  1. #1
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139

    How to stop multiple workbooks from opening

    I have multiple workbooks opening anytime I open a workbook new or existing. How can I stop this?
    Last edited by novice2430; 01-12-2010 at 10:34 AM.

  2. #2
    Forum Contributor
    Join Date
    02-14-2007
    Location
    Chester, England
    MS-Off Ver
    2010 & 2016
    Posts
    312

    Re: How to stop multiple workbooks from opening

    Hello

    Not too sure what you mean but when you open a new workbook you can change the number of sheets but clicking on the "office icon" and selecting "Excel Options". In the Popular Tabs there is an option that says "Include this many Sheets" change that to 1 and it should stop you getting Sheets.

    Is this what you needed?

    Cheers

    Jim

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to stop multiple workbooks from opening

    Excel Options > Advanced > General, anything in the box labeled At startup, open all files in ...?
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139

    Re: How to stop multiple workbooks from opening

    Quote Originally Posted by shg View Post
    Excel Options > Advanced > General, anything in the box labeled At startup, open all files in ...?
    No there's nothing in that box.

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How to stop multiple workbooks from opening

    If it's the same workbooks that open every time, check the two XLSTART folders on your system and see if there are any workbooks in there.
    Remember what the dormouse said
    Feed your head

  6. #6
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139

    Re: How to stop multiple workbooks from opening

    Quote Originally Posted by JimmyA View Post
    Hello

    Not too sure what you mean but when you open a new workbook you can change the number of sheets but clicking on the "office icon" and selecting "Excel Options". In the Popular Tabs there is an option that says "Include this many Sheets" change that to 1 and it should stop you getting Sheets.

    Is this what you needed?

    Cheers

    Jim
    Thanks for the reply, That changes the sheets within the current workbook. I have 4 workbooks opening when I choose a new or existing workbook to open. They happen to be the last 4 workbooks that I saved.

  7. #7
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139

    Re: How to stop multiple workbooks from opening

    How do I access the XLSTART folders?

  8. #8
    Forum Contributor
    Join Date
    06-24-2008
    MS-Off Ver
    2007
    Posts
    139

    Re: How to stop multiple workbooks from opening

    Found it, and that I see that the four workbooks are in there thanks!

+ 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