Status Bar Sum Total Disappears

Hi

This may help!

(I am using excel 2016)

When you have your first excel doc. open. 

Press: Shift + Ctrland click on the excel icon. (you may need to press it a few times in rapid succession)

This has worked for me. You will see it works on the doc. that loads a new doc. Not the ones that open instantly.

Sadly a not a totally repayable way to do something that should never been taken out.

Hope this helps you!

I believe the "Newer" way to handle this is to add a cell that has your Sum formula on each workbook.

Then add the "Watch Window" to Excel.

This allows one to monitor multiple cells in one location.

This has less chance of errors and confusion over what and where things are selected.

I've been using this more and more.

One can use the Status bar in many variations.  But, it's probably not the best way.

Sub Demo()

    Dim x, y

    x = WorksheetFunction.Sum(Range("[Book1]Sheet1!$A$1:$A$10"))

    y = WorksheetFunction.Sum(Range("[Book2]Sheet1!$A$1:$A$10"))

    Application.StatusBar = "Book1: " & x & "   " & "Book2 " & y

End Sub

To have to open separate instances of Excel continually ALL Day Long is counter-productive. I too use the total when posting from ledgers to accounts. Please Microsoft,  just fix the bug.. I can't imagine why it would be an issue for Microsoft to allow a total to remain in the bottom cell - When it is definitely a feature many people have used in the past.

You clearly don't "listen to all feedback and consider them for additional feature/future versions of our products" - all these complaints date back from January 2014 - it is now November 2016 and I have just been "upgraded" to Excel 2013 - the issue is still here!  This is the most frustrating part about being forced to take new software - the fact that these companies obviously don't use their own products, and change the look and features of the product just to justify a new release, without consultation with their customers who actually do use the product.  This is the biggest time waster in our working day!

I also suffer from this on upgrading to Office Professional 2016.

Strangely, I didn't get around to Activating the product until the nag screens appeared.  For nearly a month I was using excel before activation, and it did not behave in this way.  After activation it does.  To me, this suggests that it would not be impossible for MS to reverse this particular mistake.

Personally, this change reduces excels usefulness to me considerably and will cause me a lot of extra work.

Please please release a patch.

Jon