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

55 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-09T15:16:19+00:00

    Creating a new instance is unfortunately the only way (apparently) to get this to work in Excel 2013/16 right now.

    If opening a new instance via ALT is problematic, maybe you'll wish to try this:

    • Find your excel.exe binary.
    • Copy and create a symbolic link in a convenient place (i.e. usually your desktop)
    • Open properties of your symbolic link
    • In the line for your link's target add ' /x' after the ...\excel.exe" (i.e. ...\excel.exe" /x)

    Now every time you start Excel with that symlink, it will open a new instance.

    Unfortunately those have their separate issues, especially when it comes to copy&paste...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2016-02-01T23:05:25+00:00

    I just have to say that this is not good enough. Taking away a feature then offering a work around that doesn't even work (I'm already running a multiple instances tweak to make it excel usable with multiple spreadsheets in the first place). I previously used this function multiple times a day. Now my only option is sum, quickly memorise the number, switch to the other spreadsheet, type it in before I forget it, then check I got it right. With all the distractions you get in your average office (and every other number in your head), this is a major pain and error prone.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2015-08-13T16:53:16+00:00

    I agree with the rest of the group. My office just "upgraded" to 2013 as well and the removal of this feature is a huge inconvenience. I work on multiple workbooks often and used the feature to add items in one workbook and put the total in a second. Now if I forget the total, I have to click back on the original spreadsheet, then click back on the second. Please put out a patch to bring this feature back!

    This is the same situation for me. This feature has always been present in past versions of Excel. Does Microsoft even use its own product? Because if they did, they would have noticed this and would realize why it is such a big deal for this feature to be missing. This is a shocking oversight that makes their product less productive and could not have been intentional. Someone at Microsoft goofed pretty big on this one and it's sad they are not working to fix it.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2015-07-09T13:24:54+00:00

    I agree with the rest of the group. My office just "upgraded" to 2013 as well and the removal of this feature is a huge inconvenience. I work on multiple workbooks often and used the feature to add items in one workbook and put the total in a second. Now if I forget the total, I have to click back on the original spreadsheet, then click back on the second. Please put out a patch to bring this feature back!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2015-07-01T15:04:12+00:00

    This is a terrible update and could not be less helpful to me in my day to day work.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments