This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
This is still an issue. Hard to believe that newer versions are less user friendly. I hope this gets fixed.
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!
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?
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.
Same with me - no error but it doesn't solve the problem of sums disappearing when I Alt-Tab to another open spreadsheet.