+ Reply to Thread
Results 1 to 9 of 9

View Side by Side?

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    View Side by Side?

    I can't pinpoint the timing of my issue. I just got the windows 10 upgrade on a machine I've had for a few weeks using office 2010.

    I have a few everyday files pinned to my taskbar and they all open in separate windows and the ability to view them side by side isn't available. However if I open them using file > open and then navigate to the file location I'm able to go to a side by side view with as many workbooks as I want if I open them using this method. This kind of defeats the point of having them pinned for easy access though.

    Maybe this example helps:
    - I open 3 files that I have pinned to my taskbar.
    - I can take one of those workbooks and go to file > open and then open another notebook.
    - By doing this in the same window I can use the control+tab and flip between these 2 workbooks, but I cannot with the other 2 workbooks I opened via the pinned taskbar.

    I've tried googling and to no avail. I'm not sure if I need them opened in the same window and excel is by default opening each workbook in its own separate window? Any help is appreciated.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: View Side by Side?

    Hi,

    According to a thread on the MS forums (http://answers.microsoft.com/en-us/o...ceadf44?auth=1), this is what you need to do:
    Click 'File', then 'Options', then 'Advanced', then scroll down to the 'General' section and uncheck the box labelled 'Ignore other applications that use Dynamic Data Exchange (DDE)'.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: View Side by Side?

    I've already done that and to no avail...

    Maybe it's worth noting that each file I open using my pinned files opens in a new occurrence of excel and therefore a new window.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: View Side by Side?

    Try the advice from here: http://www.ozgrid.com/forum/showthread.php?t=158173
    Step 1 is what I already suggested, but Step 2 onwards might work.

    If nothing from there works, it might be a problem with an add-in (as referred to here: http://dailydoseofexcel.com/archives...#comment-73558) - if you have any add-ins, maybe try disabling them and see if that makes a difference?

    Good luck.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: View Side by Side?

    Thanks, but the same thing, still opening multiple instances when I want one single excel.exe.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: View Side by Side?

    Maybe it's worth noting that each file I open using my pinned files opens in a new occurrence of excel and therefore a new window.
    Thats your problem there. If you want to "arrange" excel windows, then all those files need to be opened in te same instance of excel. By opening them each in their own instance of excel, it's like opening Word, Powerpoint, Excel and Internet explorer, and trying to "arrange windows" from inside excel.

    If you have a "set" or excel files that you always open together, try using the WorkSpace option (I am running 2013, and apparently that option has been removed) With WorkSpace, you open a few excel files, arrange them as needed, and SaveAs .xlw
    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

  7. #7
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: View Side by Side?

    I can try that, but that's not my problem. Your solution feels like a bandaid- no offense, but I'm extremely frustrated. I know I need them all to open in the same instance, but that's the problem they don't. Each file I open starts a new instance of excel- I've validated that by using the task master. If I have 5 excel open (or any office file type) I have 5 instances of excel running. I had this functionality with windows 7 (only having one instance of excel, word, etc), but since the upgrade to 10 there have been some tweaks I've had to work through.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: View Side by Side?

    It is not a band-aid, it is a powerful tool for opening a set of files in specific locations - that is what it was designed for (and I have no idea why they dropped it from 2013)

    You set it up once, arranging all the windows as you want, Save As, then when you want to open them all again, you just open that single .xlw file - and ALL the "contained" files open in the positions you set. I dont use it much now, but I used to use it extensively for up to 10 files

  9. #9
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: View Side by Side?

    My 2 cents worth and not sure if this is the solution you want.

    I think the issue is caused by the pinning of those spreadsheets. Every time you access the file via the taskbar, you are telling it to open it in a new instance of Excel. Does double clicking an on Excel file, say from the desktop opens it in a new instance of Excel too?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. View 2 worksheets in the same workbook (side by side)
    By Xx7 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-21-2016, 11:32 PM
  2. Replies: 0
    Last Post: 02-04-2015, 07:02 AM
  3. Hw do i view two sheets side by side?
    By Joe Miller in forum Excel General
    Replies: 9
    Last Post: 09-18-2014, 10:52 AM
  4. Excel 2007 : View - Side by Side - Zooming problem
    By DB2012 in forum Excel General
    Replies: 1
    Last Post: 03-04-2012, 04:45 PM
  5. vertical side-by-side view
    By tevans@jfti.com in forum Excel General
    Replies: 4
    Last Post: 01-18-2012, 08:14 PM
  6. Replies: 3
    Last Post: 12-30-2011, 01:16 PM
  7. How to view two or more Excel documents side by side...
    By id2nv2nj2ca in forum Excel General
    Replies: 9
    Last Post: 11-05-2009, 03:30 PM

Tags for this Thread

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