A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Will this option be added back in future updated? I have been using this feature since the 2003 version of Excel.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Will this option be added back in future updated? I have been using this feature since the 2003 version of Excel.
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.
OMG you just saved my life with this comment. My work life has been drastically made worse by this horrible update to Excel, and I hadn't found a workaround for the last several months. I am so glad I kept reading through this thread. Thank you thank you!
Will this option be added back in future updated? I have been using this feature since the 2003 version of Excel.
I just had Microsoft Office updated to 2016 (5-6-16). My current set up is that I have two monitors for ease of generating large and complex budget files. In my previous software, 2010, I could have two instances of Excel open, one on each screen, and on one screen I can sum up some cells to get a "sum." The status bar would hold that information so I could go to the other screen, and input that "sum" in a new budget sheet.
Now, with the upgrade, as soon as you click outside of the "summed" information, the information disappears on the status bar. This is so frustrating when you are working on complex budgets and need that information. Now I result to writing down the number or using my 10-key calculator to put the number in. So inefficient and generates errors.
Microsoft, why did you remove this function? It is a VERY valuable tool to us folks that work with budget numbers. Can you please provide a patch that brings that back?
Kindly,
Teresa