+ Reply to Thread
Results 1 to 4 of 4

Retain SUM in status bar when switching to another Excel window

  1. #1
    Registered User
    Join Date
    01-07-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    24

    Retain SUM in status bar when switching to another Excel window

    We recently switched to Excel 2013 at work (had 2007 prior to that). Under Excel 2007, I could open up a window/file and then open another file in a separate window/instance of Excel 2013 and have them on two different screens. If I needed summation info from one file, I could highlight the cells and the sum would show in the lower status bar, when I would switch to the other Excel screen, the sum would remain/still show on the other screen.

    With Excel 2013 if I try to do this, the sum disappears from the status bar when I go to the other Excel file. If I go back, it shows back up.

    Is there a way to force Excel 2013 to continue to show this when I switch screens? I have tried what I did before (open one file, then go to start menu and open another Excel 2013 which opens a new/blank document, at which case I open the second file), but it no longer works.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Retain SUM in status bar when switching to another Excel window

    If you have the two instances of Excel on one screen side by side do you have the same problem?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    01-07-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Retain SUM in status bar when switching to another Excel window

    Sorry, I just had a chance to test this. Same screen does not seem to matter, the sum still disappears from the one when you make the other the active.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Retain SUM in status bar when switching to another Excel window

    This might be just how Excel 2013 works. I have heard that there are some strange things that Excel 2013 does and this might be one of them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 07-23-2014, 06:15 AM
  2. [SOLVED] Different Screenupdating status in VBA Code Window than Immediate Window
    By ArnolddG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2014, 11:14 AM
  3. [SOLVED] Switching between sheets in same window...
    By Kojones in forum Excel General
    Replies: 1
    Last Post: 07-16-2005, 06:05 PM
  4. [SOLVED] switching from one window to another
    By Sergiek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2005, 12:05 AM
  5. How do I retain blank cell status in an IF statement?
    By HWI in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1