Empty status bar
 

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

Empty status bar
 

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


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom


"Jeannie" wrote in message
...
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

Empty status bar
 

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

"Peo Sjoblom" wrote:

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


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom


"Jeannie" wrote in message
...
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

Empty status bar
 

Hi Jeannie

try
ToolsOptionsViewcheck Status Bar

--

Regards
Roger Govier

"Jeannie" wrote in message
...
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

"Peo Sjoblom" wrote:

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


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom


"Jeannie" wrote in message
...
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

Empty status bar
 

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

"Roger Govier" wrote:

Hi Jeannie

try
ToolsOptionsViewcheck Status Bar

--

Regards
Roger Govier

"Jeannie" wrote in message
...
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

"Peo Sjoblom" wrote:

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


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom


"Jeannie" wrote in message
...
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

Empty status bar
 

So didn't the workaround using SUBTOTAL work?


--


Regards,


Peo Sjoblom



"Jeannie" wrote in message
...
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

"Roger Govier" wrote:

Hi Jeannie

try
ToolsOptionsViewcheck Status Bar

--

Regards
Roger Govier

"Jeannie" wrote in message
...
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

"Peo Sjoblom" wrote:

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


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom


"Jeannie" wrote in message
...
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

Empty status bar
 

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

"Peo Sjoblom" wrote:

So didn't the workaround using SUBTOTAL work?


--


Regards,


Peo Sjoblom



"Jeannie" wrote in message
...
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

"Roger Govier" wrote:

Hi Jeannie

try
ToolsOptionsViewcheck Status Bar

--

Regards
Roger Govier

"Jeannie" wrote in message
...
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

"Peo Sjoblom" wrote:

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


there is also a workaround using SUBTOTAL on the same page


--


Regards,


Peo Sjoblom


"Jeannie" wrote in message
...
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