Results 1 to 2 of 2
  1. #1
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    starting Excel 2013 opens extra empty workbooks

    Hello all,
    We recently changed from Office 2007 to 2013 and now I have some problems with Excel.
    When staring Excel or opening a workbook from the explorer, Excel will open some extra empty workbooks. So far I can reconstruct it has something to do with activated plugins (linke Analysis Toolpack,...) and some hidden startup workbooks with macro's from my XLstart folder.
    But sometimes Excels just starts the right way with just one instance.
    My IT department says this is the normal way Excel 2013 behaves, but I'm in disbelieve.

    When closing Excel most of the time I have to use the Taskmanager to close the extra empty workbooks.

    Can anyone tell me more about this?
    Last edited by siflaar; 2016-03-22 at 02:45.
    Greetings,

    Patrick Schouten
    (The Netherlands)

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Patrick

    Prior to Excel2013, one 'session' of Excel could 'contain' multiple workbooks. This is called a 'Multiple Document Interface' (MDI). You would only see a single Excel in the Windows Task Bar. From Excel 2013 onwards, the application is now a Single Document Interface (SDI). This means that multiple opened Excel workbooks are now in separate Excel windows, each workbook with its own Ribbon.

    This change has an impact for Excel add-ins because all the workbook level events, methods and properties now operate on the top level window.

    In dual-monitor systems, the SDI in Excel enables side-by-side comparisons of two workbooks by dragging each workbook to a different monitor. Each workbook works independently of the other.

    With SDI, a workbook cannot be closed by clicking the red "X" Close button when that workbook is programmatically opened via a modal user form. One option is to open the workbook window, activate any other window, and then reactivate the workbook window. You should now be able to close the workbook using the red "X" Close button.

    zeddy

Posting Permissions

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