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 No comments

55 answers

Sort by: Most helpful
  1. Anonymous
    2018-04-17T18:41:35+00:00

    I tried it as well. I did not get the error that you indicated, but it did not solve the problem for me. The sum still goes away as soon as I click on the other worksheet.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2018-04-17T18:38:27+00:00

    I was excited to FINALLY see a solution to this "sum" problem. However, when I checked the box as instructed, none of my Excel workbooks will open and I get an error of "There was a problem sending the command to the program." Anyone else getting this error?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2018-04-17T15:05:40+00:00

    Go to file --> options --> advanced --> check the box that says "ignore other applications that use Dynamic Data Exchange (DDE). It will open all excels as a new instance and thus leaving the sum there!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2018-04-03T21:25:18+00:00

    This is still an issue. Hard to believe that newer versions are less user friendly. I hope this gets fixed.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2014-11-04T16:24:44+00:00

    We just switched to Excel 2013 and are having this same issue.  Did you ever figure out a solution?  thanks!

    Was this answer helpful?

    0 comments No comments