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
    2017-04-04T15:16:47+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.

    This is still an issue in Excel 2016 - the sum in the status bar disappears when you change focus to another Excel worksheet. Interestingly, it doesn't disappear if you switch focus to another program window - such as Word or Outlook.

    I assume this is related to the fix MS deployed to the multiple windows issue Excel has had forever - not being able to open two separate files in separate windows (you had to run separate instances of Excel). That problem has been fixed (finally), but now this issue has arisen.

    I use this quite a lot so I hope they can fix it - I'll have to resort to writing the sums using pencil and paper for now.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-06-27T17:00:07+00:00

    Our offices have been updated with this Microsoft Office 2013 version.  A lot of us have been using this feature for so long and now it's gone.  Will there be any way to fix this issue ASAP?  Thanks.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-07-25T19:47:26+00:00

    Has this bug been corrected yet? I really need this to work for a dual monitor situation. I use the sum to post from one form to another multiple times per day.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-07-25T20:09:56+00:00

    If you open another instance of Excel those results will still remain because it see's both instances as active windows.

    This is how: How to Run Separate Instances. (also seen in one of Jude Wong's reply's)

    Was this answer helpful?

    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more