Status Bar Sum Total Disappears

Anonymous
2014-01-15T20:49:51+00:00

I use a two monitor system and will have MS Excel 2013 running on both.  On one monitor I can select a range of numbers and the sum total will show in he status bar.  When I select a cell in the workbook on my other monitor the sum total disappears.  Is there a way to not have the sum total disappear?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

55 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-01-16T17:32:43+00:00

    Hello Steve,

    Thank you for posting your query in Microsoft Office Community.

    A quick question before proceeding:

    Do you have multiple instance of Excel files open?

    If the above is true, this is an expected behavior as Excel will only show the Average/ Sum/ Count result in the active Excel window.

    As you're changing focus of the mouse by going to the workbook in second monitor, the result of the first monitor changes as it goes in active. There is no option to change this behavior.

    Reply if you need further assistance and I'll be happy to help you.

    Thank you.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2014-02-23T14:50:55+00:00

    This behavior did not exist in Excel 2010 though.  It was a lot more convenient to compare two spreadsheets this way.

    It is disappointing to know that this option is no longer available in Excel 2013.

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  3. Anonymous
    2014-04-25T14:52:17+00:00

    Will this option be added back in future updated?  I  have been using this feature since the 2003 version of Excel.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  4. Anonymous
    2014-04-25T15:00:15+00:00

    Will this option be added back in future updated?  I  have been using this feature since the 2003 version of Excel.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  5. Anonymous
    2014-05-20T15:25:15+00:00

    Hi all,

    Apparently there is a workaround, see Opening workbooks by running separate instances of Excel.

    I still find it cumbersome but it works.

    Was this answer helpful?

    40+ people found this answer helpful.
    0 comments