Status Bar Sum Total Disappears

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?
 

Question Info


Last updated May 16, 2019 Views 27,296 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

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.

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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.

Best regards,

Jude.

11 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

6 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi all,

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

I still find it cumbersome but it works.

Best regards,

Jude.

35 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi cbw1991,

Yes, by running a separate instance of Excel. See the link in my reply to MJones732.

Best regards,

Jude.

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

This is insane . . . I always thought the user/customer was right . . . . Several of us have addressed how this feature was VALUABLE to us !!!  I deal with millions of dollars and am (or should I now say WAS) constantly using this feature.  Thank you for making my job harder!!!

6 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Can't believe you haven't put a patch for this issue

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Our office just switched to 2013, and this among a few other reasons is why I absolutely HATE MS Office 2013. I work with money all day and this feature in 2010 was extremely useful for me, the fact that it was removed is just stupid.

20 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.