Empty status bar

[Jeannie]

One of our users has a status bar which is completely empty, there is no
auto-filter or even ready written on it. I have right-clicked on the bar and
tried every single option, but none appears. I have modified the calculation
option, and nothing appears. I am at a loss as to what to do. I open the
same spreadsheet on my computer and the count is there when I filter a column.
Any help would be greatly appreciated
Thanks
Jeannie

 

[Peo Sjoblom]

http://www.contextures.com/xlautofilter02.html#Count


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom

 

[Jeannie]

I've tried everything appearing on that link and nothing works since the
status bar does not give any information at all, this seems to work only if
the status bar has a mention such as ready or autofilter on it.
Any other suggestions would be greatly appreciated

 

[Roger Govier]

Hi Jeannie

try
Tools>Options>View>check Status Bar

 

[Jeannie]

Actually the status bar is visible, since I can see the "num" on the right
side when NumLock is on, however, nothing shows on the left side
Any other suggestions would be greatly appreciated

 

[Peo Sjoblom]

So didn't the workaround using SUBTOTAL work?


--


Regards,


Peo Sjoblom

 

[Stuart]

I have this problem too.

It's where Excel does an autosum to the left of the numlock indicator on the
status bar.

Although I right click on the area and choose and option it still doesn't do
an autosum.

Stuart